2 SQL queries

Anon

I need to do an INSERT on one table and an UPDATE on another table. When I run the script only the first query is being run.
When I comment out either one, the other query runs fine.

Any ideas?

mysql_query("INSERT INTO changes (field1,field2,field3,time) VALUES ('$dataWrong','$dataCorrect','$program',NOW(''))",$db);

mysql_query("UPDATE table SET field1='$dataCorrect' WHERE field1='$dataWrong'",$db)

Anon

if this is the actual code........

mysql_query("INSERT INTO changes (field1,field2,field3,time) VALUES ('$dataWrong','$dataCorrect','$program',NOW(''))",$db);

mysql_query("UPDATE table SET field1='$dataCorrect' WHERE field1='$dataWrong'",$db)

...........add ";" after the second query's ")" . Happy Coding!

Anon

No, sorry, I forgot that... Reminder that if I had forgotten the ';' I'd be getting a parse error.

No errors are given.

Anon

I got the fix.

I have to take off teh 'or die()' directive. I didn't realize the OR die was just like an if/else statement in it's ordering.

After the first query ran it was done. beacuse it was told, do (query) or die. Not do (query) and go on...

All fixed.

Anon

The issue still remains.. I thought it was fixed but I was incorrect, any assistance would be great.

Anon

How about:

$sql = "INSERT INTO changes (field1,field2,field3,time) VALUES ('$dataWrong','$dataCorrect','$program',NOW(''))"

$sql2 = "UPDATE table SET field1='$dataCorrect' WHERE field1='$dataWrong'"

$result = mysql_query($sql, $db);
$result2 = mysql_query($sql2, $db);