DUH!!!! Why didn't I see that..
Thanks..
Chris
Miles Thompson wrote:
> Well, did you try looping though tables with mysql_fetch_array($tables)?
>
> But, how 'bout mysql_list_tables()?
>
> Cheers - Miles Thompson
>
> PS There's a bunch of other interesting stuff relating to database
> manipulation there too. /mt
>
> At 11:48 AM 1/12/2002 -0800, Chris wrote:
> >I'm trying to display the tables in my database using $tables =
> >mysql('mydb", "SHOW TABLES FROM mydbname") but this statement doesn't
> >seem to behave like selecting records from a table. Does this query
> >return an array of table names? If I use something like $records =
> >mysql('mydb", "SELECT * FROM sometable) everything works fine. There
> >must be something I'm missing about the SHOW query.
> >
> >Thanks
> >Chris Williams
> >
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
