Anil Labs

Wednesday, March 24, 2010

How to get list of table names from database in mysql?

2 comments:

  1. mysql_list_tables is already depricated. You should use mysql_query() to issue SHOW TABLES command. Refer to the PHP Manual for additional details.

    ReplyDelete
  2. Use $num_tables instead of $num_rows in for loop on the above mention code than it works fine.

    ReplyDelete