Re: How to show table???

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 <kelvin_y@decode-ent.com> 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > #-------------------------------------------------------# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam e: r.j.michell@apu.ac.uk w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #-------------------------------------------------------#