I would like to update FIVE records a once.
I usually do one at a time like this:
$sql = "UPDATE adverts SET views = viewS+1 lastviewed = '$today' WHERE advert_id = $this_ad";
mysql_query($sql) or die("could not UPDATE adverts - BlockType B ". mysql_error());
The 5 adverts have ids
How should I do a multiple update ?PHP Code:
advert_id = $ad_A;
advert_id = $ad_B;
advert_id = $ad_C;
advert_id = $ad_D;
advert_id = $ad_E;
Do I insert a series of AND's ?