...

View Full Version : displaying table names



Bob42
11-04-2007, 03:04 PM
It's easy enough to display the rows that are in a table onto a webpage, but how would I display the actual names of the tables that are in the mySQL database?

Inigoesdr
11-04-2007, 04:48 PM
SHOW TABLES FROM `database` or if you have the database selected you can simply
SHOW TABLES
ref (http://dev.mysql.com/doc/refman/5.0/en/show-tables.html)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum