[PHP-DB] need help with SHOW COLUMNS

[David Rice]

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


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php