Mysql多个PHP查询，跳过

Question

If i'm doing multiple mysql queries on the same table, occasionally some get skipped.

Why is that?

For example:

<?php
mysql_query("UPDATE `tb` SET `field` = '' WHERE `Id` = '$something'"); 
mysql_query("UPDATE `tb` SET `field2` = '' WHERE `Id` = '$something'"); 
mysql_query("UPDATE `tb` SET `field3` = '0' WHERE `Id` = '$something'");
?>

Sometimes one of the queries will not be executed?

Why is that?

-Or is it something wrong with my server not general mysql?

(Obviously I know now to update the same table in the same query, but before that I was very confused as to why it happens, can anyone please explain?)

Thanks!

Answer 1

debug your code to see if a query fails:

$result = mysql_query("UPDATE `tb` SET `field` = '' WHERE `Id` = '$something'");
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

$result = mysql_query("UPDATE `tb` SET `field2` = '' WHERE `Id` = '$something'");
if (!$result) {
    die('Invalid query: ' . mysql_error());
}

$result = mysql_query("UPDATE `tb` SET `field3` = '0' WHERE `Id` = '$something'");
if (!$result) {
    die('Invalid query: ' . mysql_error());
}