mysql query for alternating update
Posted on 2012-03-27
I need to update a table so that the field 'series' alternates between 'a' and 'b'.
Something like this:
mysql_select_db(oys) or die("Unable to load update into mysql");
$query = "UPDATE oys_sites SET `series`=
//at this point, I need the 'series' field in the first row set to 'a', the next row set to 'b', then 'a', then 'b', alternating, until all rows are done.
This will be entered into a php script so I can set it when needed.
Thanks for any help writing this up,