Im trying to use the SHOW COLUMNS Syntax from mysql in the folowing code. 
It is returning nothing.The Table name is correct and there are records in 
the table (not that that should matter).I dont get an error.I posted to 
php.general and got no response.

$query="Show Columns from Inventory";
$result= mysql_query($query);
while ($row = mysql_fetch_row($result));
for ($i =1;$i<mysql_num_fields($result);$i++)
{echo $row[$i];

Mike P

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to