Re: [PHP] List tables

2003-03-20 Thread Alin
On Thu, 2003-03-20 at 17:09, Alin wrote: if you are using mysql try: $query=show tables; $result=mysql_db_query(database-name,$query) or die(Query error); whlie(list($table-name)=mysql_fetch_row($result)){ echo Columns from $table-name: br; $query=show columns from $table-name;;

RE: [PHP] List tables

2003-03-16 Thread daniel
use mysql_list_tables ? = Original Message From shaun [EMAIL PROTECTED] = 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

[PHP] List tables

2003-03-15 Thread shaun
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 General Mailing List

Re: [PHP] List tables

2003-03-15 Thread Miles Thompson
As noted earlier, in the manual and please don't cross post. Miles At 05:37 PM 3/26/2003 +, shaun wrote: 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