[SOLVED] Combining MySQL UPDATE queries

[amites]

Anyone know why

 

	$query = "UPDATE bil_msg_sent SET active='1', SET payment='CM' WHERE id='".$id_num."'";

 

and

 

	$query = "UPDATE bil_msg_sent SET active='1' WHERE id='".$id_num."'";

 

would work, yet combining them to

 

	$query = "UPDATE bil_msg_sent SET payment='CM' WHERE id='".$id_num."'";

 

doesn't??

[revraz]

If you gave us the error it would be easier to see why.

 

And I think you have your order mixed up, the top one is the combined one.

[phorcon3]

<?php
$query = "UPDATE bil_msg_sent SET active='1', payment='CM' WHERE id='".$id_num."'";
?>

[amites]

seems to happen after I've beens staring at code to long, it all starts to blur a little...

 

many thanks