Running 20 small update queries consecutively...

[Lurk]

$sql_weeks = "UPDATE Monday SET Week = 3 WHERE Week = 1; 
			UPDATE Monday SET Week = 1 WHERE Week = 2; 
			UPDATE Monday SET Julian=0,Graham=0,Dale=0,Plumbing=0 WHERE Week = 3; 
			UPDATE Monday SET Week = 2 WHERE Week = 3;
			UPDATE Tuesday SET Week = 3 WHERE Week = 1; 
			UPDATE Tuesday SET Week = 1 WHERE Week = 2; 
			UPDATE Tuesday SET Julian=0,Graham=0,Dale=0,Plumbing=0 WHERE Week = 3; 
			UPDATE Tuesday SET Week = 2 WHERE Week = 3;
			UPDATE Wednesday SET Week = 3 WHERE Week = 1; 
			UPDATE Wednesday SET Week = 1 WHERE Week = 2; 
			UPDATE Wednesday SET Julian=0,Graham=0,Dale=0,Plumbing=0 WHERE Week = 3; 
			UPDATE Wednesday SET Week = 2 WHERE Week = 3;
			UPDATE Thursday SET Week = 3 WHERE Week = 1; 
			UPDATE Thursday SET Week = 1 WHERE Week = 2; 
			UPDATE Thursday SET Julian=0,Graham=0,Dale=0,Plumbing=0 WHERE Week = 3; 
			UPDATE Thursday SET Week = 2 WHERE Week = 3;
			UPDATE Friday SET Week = 3 WHERE Week = 1; 
			UPDATE Friday SET Week = 1 WHERE Week = 2; 
			UPDATE Friday SET Julian=0,Graham=0,Dale=0,Plumbing=0 WHERE Week = 3; 
			UPDATE Friday SET Week = 2 WHERE Week = 3;";

mssql_query($sql_weeks,$db) OR DIE("Failed updating weeks");

Why would this queery fail to run? I get the "Failed updating weeks" error from the DIE text... Is this the right way to update these tables?

All I want to do is to make all the records with "week=2" change the value of "week" to 1, and I want to blank all the name fields where "week=1"and set them to have the value of "week=2".

Where is this falling down? Thanks.

[Sxooter]

Due to issues with sql injection, most newer versions of PHP do not allow more than one query per db_query call.

I do it this way:

$sql[] = "update table abc ...";
$sql[] = "update table def ...";
$sql[] = "insert into table ghi ...";
foreach($sql as $s){
  $r[] = db_query($s);
}