MySQL in a Nutshell

Name

mysql_fetch_field( )

Synopsis

mysql_fetch_field(results[, offset])

This returns an object containing information about a field from a results set given. Information is given on the first field of a results set waiting to be returned; the function can be called repeatedly to report on each field of a SELECT statement. A number may be given as the second argument to skip one or more fields. The elements of the object are as follows: name for column name; table for table name, max_length for the maximum length of the column; not_null, which has a value of 1 if the column may not have a NULL value; primary_key, which has a value of 1 if the column is a primary key column; unique_key, which returns 1 if it’s a unique key; multiple_key, which returns 1 if it’s not unique; numeric, which returns 1 if it’s a numeric datatype; blob, which returns 1 if it’s a BLOB datatype; type, which returns the datatype; unsigned, which returns 1 if the column is unsigned; and zerofill, which returns 1 if it’s a zero-fill column.

...
$sql_stmnt = "SELECT * FROM workreq LIMIT 1";
$results = mysql_db_query('workrequests', $sql_stmnt);
$num_fields = mysql_num_fields($results);
for ($index = 0; $index < $num_fields; $index++) {
  $info = mysql_fetch_field($results, $index);
  print "$info->name  ($info->type $info->max_length) \n";
}
...

Here all of the columns for one record are selected and placed in $results. The number of fields is determined by mysql_num_fields( ) for the for statement that follows. The