Catching sql quey errors

[Anon]

Hi there,

I am running PHP4 against a mySQL database and have the following simple database query which needs to run:

$dbcity->query("select state, town from $CityDBtable where state = \"$fldstate\" order by 2");

My simple question is how to catch/trap the error that gets displayed IF the TABLE that is being called in the query does not exist?

Thanx
Grant

[Anon]

Try to put @ in front of the function to suppress "ugly" warning and use die() to print message if the function fails:

$result=@($sql, $connection) or die("Could not execute query.");