Limit second and third sql if no insert

Question

I got on my php script

$result1 = mysql_query("insert ignore into...this....
$result2 = mysql_query("insert into...that....
$result3 = mysql_query("insert ignore...again

those all are different queries.

when first query tries to insert, and if it has duplicate record, it does not enter this.

well I dont want to run second and third query, if first query did not enter anything.

How do I prevent 2 and 3 query running if first did not enter anything? in PHP please.

Thanks

Answer 1

Use the mysql_affected_rows function to get the number of affected rows:

$result1 = mysql_query("insert ignore into...this....");
if (mysql_affected_rows($result1) > 0) {
    $result2 = mysql_query("insert into...that....");
    $result3 = mysql_query("insert ignore...again");
}

Answer 2

I cannot try it out myself right now, but it looks like mysql_affected_rows() may be able to accomplish what you are looking for.

Answer 3

You should use a transaction:

mysql_query("begin");
$result1 = mysql_query("insert ignore into...this....");
if (mysql_affected_rows() > 0) {
    $result2 = mysql_query("insert into...that....");
    $result3 = mysql_query("insert ignore...again");
    mysql_query("commit");
} else {
    mysql_query("rollback");
}

EDIT: This will only work if your tables are InnoDB. MyISAM tables do not support transactions.