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,