http://us2.php.net/manual/en/function.mysql-list-tables.php http://us2.php.net/manual/en/function.mysql-list-fields.php you should really check the manuals before posting... they are built right in... Joel "Shaun" <shaun@mania.plus.com> wrote in message 20030315173701.91309.qmail@pb1.pair.com">news:20030315173701.91309.qmail@pb1.pair.com... > Hi, > > i would like to list all of the tables and field names in my database > > e.g. > > table 1 > field 1 > field 2 > field 3 > table 2 > field 1 > field 2 > field 3 > table 3 > field 1 > field 2 > field 3 > etc > > is there a simple way to do this? > > thanks for your help > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php