[RESOLVED] How to find table name in database?

[mrlaka94]

Hi , could you explain how to check table name in database was existed? (I have been suggested use "mysql_query()" function but still dont know how to use?)

[scross]

Try using:

<?php
$db = 'your_database';
$table = 'your_table';
$q = mysql_query('SHOW TABLES FROM `'.$db.'` LIKE \''.$table.'\'');
if(mysql_num_rows($q) > 0){
   //table exists
}else{
   //table does not exist
}
?>