need help with SHOW COLUMNS
| From: | David Rice | Date: | Tue, 05 Nov 2002 15:12:04 +0000 |
| Subject: | need help with SHOW COLUMNS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22993@lists.php.net to get a copy of this message | ||
I am tryin to create a DBMS,
the part of my code that is currently causing a problem is
mysql_select_db("filterseveuk") or die(mysql_error());
$query = "SHOW COLUMNS FROM " .$table. "";
$result = mysql_query ( $query ) or die( mysql_error () );
$numrows = mysql_num_rows ($result);
$row = mysql_fetch_array ($result);
for($x=0; $x <= $numrows; $x++){
echo $row[$x] ;
}
It produces the error
user_idint(11)PRIauto_increment
The output i want to obtain from this query is that php prints out a list of the field names.
I don't know why this is not working
How do i get it to only display the column names!?
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963