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
advert_id = $ad_A;
advert_id = $ad_B;
advert_id = $ad_C;
advert_id = $ad_D;
advert_id = $ad_E;
How should I do a multiple update ?
Do I insert a series of AND's ?
If you want to attract and keep more clients, then offer great customer support
automates the process and gives you a trust seal
to place on your website.
I recommend that you at least take the 30 day free trial