php mysql insert query

[adi123]

I have three insert queries. I would like the file to check if the query is successful before proceeding to the next page.

The if statement works fine without $result2 and $result3.

 

Here is my code:

 

<code>

 

$qry = "INSERT ";

 

$qry2 = "INSERT ";

 

$qry3 = "INSERT ";

 

$result = mysql_query($qry);

$result2 = mysql_query($qry2);

$result3 = mysql_query($qry3);

 

//Check whether the query was successful or not

 

if($result, $result2, $result3) {

header("location: success.php");

exit();

} else {

die("Query failed");

}

 

</code>

[Pikachu2000]

You should be checking that mysql_affected_rows is greater than zero for each query. Unless, of course it's OK that no record is inserted. The code you posted has a parse error, as the commas in the if() conditional should be logical && operators, not commas.