MySQL function library: mysql_field_type

Mysql_field_type

(PHP3, PHP4)

Mysql_field_type---&http://www.aliyun.com/zixun/aggregation/37954.html ">nbsp; Gets the type of the specified field

Syntax: string mysql_field_type (int result, int field_offset)

Description:

Mysql_field_type () is similar to Mysql_field_name (), and the same argument, but this function returns a form that will be "int", "real", "string", "blob", or something else, Please refer to MySQL file for details.

Example:

<?php

Mysql_connect ("localhost:3306");

mysql_select_db ("Wisconsin");

$result = mysql_query ("SELECT * from Onek");

$fields = Mysql_num_fields ($result);

$rows = mysql_num_rows ($result);

$i = 0;

$table = mysql_field_table ($result, $i);

echo "Your". $table. "' Table Super-delegates". $fields. "Fields and" $rows. "Records <BR>";

echo "The table super-delegates the following fields <BR>";

while ($i < $fields) {

$type = Mysql_field_type ($result, $i);

$name = Mysql_field_name ($result, $i);

$len = Mysql_field_len ($result, $i);

$flags = Mysql_field_flags ($result, $i);

Echo $type. ". $name." ". $len." ". $flags." <BR> ";

$i + +;

}

Mysql_close ();

?>

Compatible Mysql_fieldtype () can also be used.