execute multiple statements if mysql_query fails

Question

$query = sprintf("select * from sometable;");
$result = mysql_query($query) or die (mysql_error());

modified to:

$query = sprintf("select * from sometable;");
$result = mysql_query($query) or $DBError=true;

Now I want to execute 2 statements if the query fails, is this possible using the "short above"? e.g. something like this:

$query = sprintf("select * from sometable;");
$result = mysql_query($query) or {$DBError=true; $ErrorCode=0;}

Do you want to set result always as true or do you want to set the variables $DBError and $ErrorCode after the execution of mysql_query? Notice that documentation says that mysql_query should NOT end with ; (php.net/manual/en/function.mysql-query.php) — ClayKaboom
– ClayKaboom, Commented Jun 24, 2016 at 13:40
Just an offtopic tip: mysql library is deprecated and already removed in PHP 7. You should use the mysqli library (i for improved). — mondjunge
– mondjunge, Commented Jun 24, 2016 at 14:00

wazelin · Accepted Answer · 2016-06-24 13:00:29Z

2

You can simply use conditional statement like:

$result = mysql_query($query);
if (!$result) {
 $DBError = true;
 $ErrorCode = 0;
}

By the way. mysql_ extension is deprecated. You should use PDO.

answered Jun 24, 2016 at 13:00

wazelin

7611 gold badge11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yes, mysql is deprecated, but mysqli is not. I wouldn't recommend a complete architecture change, as it's unrelated to the OP's question.

I'm using version 5 but will look into it