Re: [PHP-DB] need help with "SHOW Colums" From: 1LT John W. Holmes (holmes072000 <email protected>)
Date: 10/31/02

So show us the code that you tried with. This code doesn't do us any good
because it's not causing the error.

---John Holmes...

----- Original Message -----
From: "David Rice" <haloplayer <email protected>>
To: <php-db <email protected>>
Sent: Thursday, October 31, 2002 11:31 AM
Subject: [PHP-DB] need help with "SHOW Colums"

>
>
>
>
>
>
>
>
> mysql_select_db("filterseveuk");
>
> $query = ( " SHOW COLUMNS FROM user ");
>
> $result = mysql_query ( $query ) or die( mysql_error () );
>
> while ( $row = mysql_fetch_array ($result) ){
>
> $x = 0 ;
>
> echo $row[$x] ;
>
> $x++ ;
> }
>
>
> I would like to replace the table name "user" with a variable $table, that
> wil automatically take the value of the selected table. I have tried many
> times but cannot get the correct sql syntax, it keeps saying
> "you have an error in your sql syntax near 'user' line 1" when i try it
with
> $table.
> any ideas??
>
> thank's,
> dave rice (haloplayer <email protected>)
>
> _________________________________________________________________
> Choose an Internet access plan right for you -- try MSN!
> http://resourcecenter.msn.com/access/plans/default.asp
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

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