Hmmm try something like:
"$sql = "EXPLAIN dbame.table_name";
This will show something like:
+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| id | smallint(3) | | PRI | 0 | auto_increment |
| firstName | varchar(30) | | | | |
| lastName | varchar(30) | | | | |
| email | varchar(30) | | | | |
| username | varchar(12) | | | | |
| password | varchar(12) | | | | |
+-----------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
I hope this is what you wanted, can't think why though...
Russ
On Fri, 24 Aug 2001 11:09:06 -0400 kelvin <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I just wonder how to list all the table when using PHP script.
> I know how to call when I in linux system. (show table) or (mysqlshow
> db_name)
>
> But don't know how to do it in PHP.... Please Help...
>
> Many Thanks.
> kelvin.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
#-------------------------------------------------------#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
t: +44 (0)1223 363271 x 2331
www.theruss.com
#-------------------------------------------------------#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]