php mysql in替代,什么是php 5中的替代函数mysql_list_tables（）

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'