SQL datatype

Anon

Is there a way to do a query and get all the names and datatypes of rows in a table? Then display them in an HTML table like this:

$total_loops = 0;
while ($field = mysql_fetch_array($result))
{
$total_loops += 1;
$value[$total_loops] = $field[0];
echo "<tr><td>display field value here</td>";
echo "<td>display field datatype here</td></tr>";
}

How can I get to the dataype?

Anon

Try this,

$conn = mysql_pconnect("localhost", "root", "");
$id = mysql_list_fields("dbname", "tablename");
$count = mysql_num_fields($id);
for ($i = 0; $i < $count; $i++) {
echo "Name:".mysql_field_name ($id, $i);
echo " Type:".mysql_field_type ($id, $i)." ";
}

Johan