Re: [PHP] List tables
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;;
$result=mysql_db_query(database-name,$query) or die(Query error);
while($columns[]=mysql_fetch_row($result)){
echo $columns[0]br;
}
}
Alin Brindusescu
CareNer Romania
[EMAIL PROTECTED]
On Wed, 2003-03-26 at 19:37, 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 2
field 3
etc
is there a simple way to do this?
thanks for your help
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] List tables
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 simple way to do this? thanks for your help -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] List tables
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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] List tables
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 2 field 3 etc is there a simple way to do this? thanks for your help -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
