databases

[Anon]

In php how do i check to see if a mysql database exists and if not, create one...

[whizkid]

Hi,

from the manual (http://www.php.net/manual/en/function.mysql-list-tables.php):

function mysql_table_exists($table,$db) {
$tables=mysql_list_tables($db);
while (list($temp)=mysql_fetch_array($tables)) { if($temp == $table) {
return 1; } }
return 0;
}

$temp = mysql_table_exists("tablename", "database");

return 1 = yes, 0 = no.

firemouse2001