Is there a Table called...

jamesm87

I want to make a SQL Query to be used in php that detects if a table exists, whithout killing the php File. It will get a list of usernames and I want to see if a table is set for each one. The table will be named by their Username. IE

Username : Table
so...
James : James

Any Idea's of a SQL Query that will do it, and how to I return it so that php detects it?

Thanks!

LordShryku

How about [man]mysql_list_tables[/man]?

tomwerner

How about :

$query = "SELECT * FROM {$username}";
$result = mysql_query($query,$connection);
if ($result !== FALSE) {
print("Sucsess, table {$username} found");
} else  {
print("Failure, User not found");
}

It tries to find that table, if it fails the error is suppressed with the @ and the if statement prints out an error if needed.

is there any reason why you have a table for every user instead of a members table with each user as a row?

jamesm87

Thanks for that,

Oh no, users get a free forum and just want to determine which users had claimed it and which did not.

Thankyou again!

ps.. Correct me if I am wrong, but should $result !== FALSE be $result != FALSE? Thanks.

tomwerner

Sorry my mistake, != means if not equal, !== means not equal or not same data type (string,float,boolean etc.), so you need != really. Was the code what you needed?