(16) int mysql_field_seek(int result, int field_offset);
为随后的mysql_fetch_field()调用设置索引。发布没有明确列号的mysql_fetch_field()的下一次调用，将返回列col_num的信息。如果搜索成功，返回真，否则返回假。
col_num的范围为0到mysql_num_fields()-1.
1
2
3$link=mysql_pconnect("localhost","sunsoft","suixiang")
4
5or die("Could not connect");
6
7mysql_select_db("stamp_db") or die("Could not select database");
8
9
10
11$query="SELECT * FROM president";
12
13$result=mysql_query($query) or die("Query failed");
14
15for($i=0;$i
<mysql_num_fields($result);$i++) %d:<br="" column="" for="" printf("information="" {="">
",$i);
if(!mysql_field_seek($result,$i))
{
print("Cannot seek to colum<br/>
");
continue;
}
$meta=mysql_fetch_field($result,$i);
if(!$meta)
{
print("No information available<br/>
");
continue;
}
print("<pre>
");
printf("blob: %s
",$meta->blob);
printf("max_length: %s
",$meta->max_length);
printf("multiple_key: %s
",$meta->multiple_key);
printf("name: %s
",$meta->name);
printf("not_null: %s
",$meta->not_null);
printf("numeric: %s
",$meta->numeric);
printf("primary_key: %s
",$meta->primary_key);
printf("table: %s
",$meta->table);
printf("type: %s
",$meta->type);
printf("unique_key: %s
",$meta->unique_key);
printf("unsigned: %s
",$meta->unsigned);
printf("zerofill: %s
",$meta->zerofill);
print("</pre>
");
}
1
2(17) string mysql_field_table(int result_id, int col_num);
3
4返回结果集给定列的表名。对于计算列，此名为空。
5
6col_num的范围为0到mysql_num_fields()-1.
$link=mysql_pconnect("localhost","sunsoft","suixiang")
or die("Could not connect");
mysql_select_db("stamp_db");
$query="SELECT * FROM president";
$result=mysql_query($query) or die("Query failed");
for($i=0;$i<mysql_num_fields($result);$i++) ",mysql_field_name($result,$i));="" ",mysql_field_nmae($result,$i));="" $d:",$i);="" %s="" print"<br="" print("column="" printf("name="" printf("table="" {="">
";
1
2(18) string mysql_field_type(int result_id, int col_num);
3
4返回结果集给定列的类型名。类型名敬请等待参考本人的另外“MySQL列类型参考”。
5
6col_num的范围为0到mysql_num_fields()-1.
$link=pconnect("localhost","sunsoft","suixiang")
or die("Could not connect");
mysql_select_db("stamp_db");
$query="SELECT * FROM president";
$result=mysql_query($query) or die("Query failed");
for($i=0;$i<mysql_num_fields($result);$i++) ",mysql_field_len($result,$i));="" ",mysql_field_name($result,$i));="" ",mysql_field_type($result,$i));="" ",mysql_fields_flags($result,$i));="" ",mysql_fields_name($result,$i));="" $link='mysql_pconnect("localhost","sunsoft","suixiang")' $query="SELECT * FROM member" $result="mysql_query($query)" %d="" %d:",$i);="" %s="" %s,="" (19)="" (20)="" ;="" ```="" col_num);="" col_num的范围为0到mysql_num_fields()-1.="" connect");="" die("could="" die("query="" failed");="" field_offset);="" for($i="0;$i<mysql_num_fields($result);$i++)" int="" mysql_field_flags(int="" mysql_field_len(int="" mysql_select_db("stamp_db");="" not="" or="" print"<br="" printf("colum="" printf("column="" printf("flags="" printf("len="" printf("name="" printf("type="" result,="" result_id,="" string="" {="" }="" 作为字符串返回结果集中给定列的相关元数据信息，如果出现错误，则返回假。这个字符串由以空格分开的词组成，说明哪个列的标记值为真。对于假的标记，在字符串中给出相应的词。="" 返回结果集给定列中值可能的最大长度。="">
";
}