Topic awaiting preservation: php mysql query help

hi there, i am using php with mysql.

in mysql you can use the sql "show tables;" to get a list of the tables in a database.

does anyone know if you can run a similar query from a php page on the web??? if so how???

THANKS

I'd imagine you could just pass that query to php->mysql_query().

If that doesn't work, I suggest you download the phpmyadmin source and see how they're doing it.

So long,

->Tyberius Prime

it did work, i just ran the mysql_db_query with "show tables"

the only thing i dont know how to do now is to list the results e.g using a while loop.

anyone know the correct syntax???

you didn't took the pain to RTFM on the page "MySQL Functions", don't you ?
The answer to you question was also given in the User Contributed Notes on the page given by Tyberius Prime.



(Edited by poi on 07-14-2004 17:25)

cool, thanks for that link. everything is working the way i had planned now. my ideas came to sudden halt when i realised that any extra tables that i might add to the database in the future would require a re-write in the code.

thanks for the help.