how can i see the structure of the db without phpmaydmin ?

VisionsOfCody

I'm working on a small dynamic site for a client and they don't want PhpMyAdmin on their servers and won't let me connect to their sql server from here (they only gave me 'localhost' for my php connections)

so this is a real pain because i can manage the db via php mysql_query but i'm kind of flying blind because i can't see directly the effect on the db

so does anyone know of a php script that i can use just to echo the structure and contents of the db tables (there are only 5 with only maybe 300 lines) in a page - like a mysql dump but displayed in a page - like in phpmyadmin) ?

thanks

Roger_Ramjet

Use DESCRIBE

VisionsOfCody

ok I'll check that out

thanks

NogDog

There's lots of variations of the SHOW statement you can use to get a variety of information, too.

VisionsOfCody

yes i noticed that whilst I was having a look at DESCRIBE in the manual

but thanks anyway 🙂