below is the code i used everything works well EXCEPT for
Deprecated: Function mysql_list_tables() is deprecated in E:\xampp\htdocs\federalcreditadvocates\admin_page\view_reports.php on line 28
it's depricated.. so what i need is simple mysql_list_tables() for php version 5 or if there is a new function for this one.. please tell me i really need it thanks :)
$table_query = mysql_list_tables("odesk_carlo");
$get_num_rows = mysql_num_rows($table_query);
for ($table = 0; $table < $get_num_rows; $table++)
{
echo "Table name: ", mysql_tablename($result, $table), "
";
}
?>
解决方案
query the information_schema DB directly:
select TABLE_NAME
from INFORMATION_SCHEMA
where TABLE_SCHEMA='yourdbnamehere'