Doesn't Exists

[Cooper94]

Is it possible say I want the system to update a table but the table dosnt exisits how would I display a error message that says such a thing?

Thank You

[premiso]

$result = mysql_query("DESC table_name") or die("Table tablename does not exist");

 

Would be one way.

 

If mysql_error is called, it will return:

Table 'bbname.tablename' doesn't exist

 

Upon an invalid tablename.

 

 

[The Little Guy]

Like this:

 

$result = mysql_query("show tables like 'dog'");
if(mysql_num_rows($result) < 1){
     echo 'Table doesn\'t exist';
}else{
     echo 'Table doesn\'t exist';
}

[trq]

Like this:

 

$result = mysql_query("show tables like 'dog'");
if(mysql_num_rows($result) < 1){
     echo 'Table doesn\'t exist';
}else{
     echo 'Table doesn\'t exist';
}

 

That'll never fly.

[The Little Guy]

Like this:

 

$result = mysql_query("show tables like 'dog'");
if(mysql_num_rows($result) < 1){
     echo 'Table doesn\'t exist';
}else{
     echo 'Table doesn\'t exist';
}

 

That'll never fly.

 

What do you mean?

[trq]

Hmmm... maybe it will. Sorry Little Guy.

[PFMaBiSmAd]

I have a question, why do you expect to be querying tables that might not exist? Do you have tables that get deleted? Once your application has been installed the tables it needs will exist and your code won't be in a position of querying a table that does not exist.

 

Your application should know what tables it uses and if you are doing something like dynamically creating tables to hold information that is the same type you already have a table for, don't create a separate table for it, use the existing table.

[The Little Guy]

I have a question, why do you expect to be querying tables that might not exist? Do you have tables that get deleted? Once your application has been installed the tables it needs will exist and your code won't be in a position of querying a table that does not exist.

 

Your application should know what tables it uses and if you are doing something like dynamically creating tables to hold information that is the same type you already have a table for, don't create a separate table for it, use the existing table.

 

 

Maybe he is a web host, and allows users one+ tables?