SHOW COLUMNS
| From: | (Mike) | Date: | Wed, 14 Mar 2001 00:30:34 +0000 |
| Subject: | SHOW COLUMNS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-7430@lists.php.net to get a copy of this message | ||
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.
<?php
require("Connection.php");
$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];
}}
?>
THANKS
Mike P
mpeloso@princeton.edu