PHP/MySQL Database/mysql fetch field
mysql_fetch_field.php
<source lang="html4strict">
<?php
mysql_connect("localhost","root",""); mysql_select_db("mydatabase"); $query = "SELECT * FROM mytable LIMIT 1"; $result = mysql_query($query); $fields = mysql_num_fields($result); for($count=0;$count<$fields;$count++) { $field = mysql_fetch_field($result,$count);echo "
$field->name $field->type ($field->max_length)
";}
?>
</source>