mysql multiple update problem

SeenGee

I'm trying to pass a query to mysql from php to update two rows in the same table. The update does not work through my website, mysql_num_rows and mysql_affected_rows both return -1 and the update does not take place. However, when i echo the sql query to the screen and insert this sql into phpmyadmin the query works.

this is the query:

$sefql = "UPDATE `slots` SET `dj_id` = '$new_slot' WHERE `dayofweek` = '$dd' AND `month` = '$mm' AND `year` = '$yy' AND `slot_no` = '$slot_no';
UPDATE `slots` SET `dj_id` = '$new_slot' WHERE `dayofweek` = '$dd' AND `month` = '$mm' AND `year` = '$yy' AND `slot_no` = '$slot2'";

Thanks.

NOTE: All vars are present.

bubblenut

use mysql_query($query,$conn) or die(mysql_error()); to get the error that's being thrown. Post it back here and we'll try to help a little more.

SeenGee

hi, the error is:

You have an error in your SQL syntax near '; UPDATE slots SET dj_id = '8' WHERE dayofweek = '05' AND month = '04' ' at line 1

as i said tho, the strange thing is that phpmyadmin has no problem with the syntax.

Thanks.

bubblenut

There shouldn't be a semi-colon and space before the UPDATE try to find out where this is working it's way in.

SeenGee

that space and semi colon are before the second Update statement(i thought the 2 statements had to be separated in some way), i've tried removing them and the query still fails.
what's the proper syntax for a multiple update if not like this?

bubblenut

You can't put more than one query in one mysql_query() statement. You have to use two statements.

SeenGee

right, i couldnt find anything that confirmed either way of that was the case or not. Thanks a lot.

bubblenut

I just realised, that was in your very first post :o :o sorry, I didn't read the query properly.
Bubble

SeenGee

all good. sometimes its the obvious ones that slip thru the net.
cheers.