Try this:
<?php
mysql_connect ("localhost","","")
or die ("Unable to connect");
mysql_select_db("beverages")
or die ("Unable to select database");
$query = "DESC drink";
$result=mysql_query($query);
while ($row=mysql_fetch_array($result))
{
echo ($row['Field']);
echo (", ". $row['Type']);
echo (", NULL=". $row['Null']);
echo (", Key=". $row['Key']);
echo (", Default=". $row[4]); //Default
echo (", Extra=". $row['Extra']);
echo (", Privileges=". $row['Privileges']);
echo ("<BR>\n");
}
?>
This will give you output like the following:
id, int(11), NULL=, Key=PRI, Default=, Extra=auto_increment, Privileges=select,insert,update,references
bev_name, varchar(50), NULL=YES, Key=, Default=, Extra=, Privileges=select,insert,update,references
location, varchar(50), NULL=YES, Key=, Default=, Extra=, Privileges=select,insert,update,references
time, time, NULL=YES, Key=, Default=, Extra=, Privileges=select,insert,update,references
date, date, NULL=YES, Key=, Default=, Extra=, Privileges=select,insert,update,references
