displaying table names

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?

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)