A
Anonymous
Guest
Forgive me, I know this is probably a very simple thing, but I just can't figure it out. I'm calling the database to bring up a random advert, using
How can I increment the value already in the 'counter' field by one?
PS - I'm a next-to-newbie with this
Code:
<?php
mysql_select_db($database_sdc, $sdc);
$query_setAdvertisers = "SELECT * FROM ttc_advertisers WHERE ttc_advertisers.type = '468x60' ORDER BY RAND()";
$setAdvertisers = mysql_query($query_setAdvertisers, $sdc) or die(mysql_error());
$row_setAdvertisers = mysql_fetch_assoc($setAdvertisers);
$totalRows_setAdvertisers = mysql_num_rows($setAdvertisers);
mysql_free_result($setAdvertisers);
?>How can I increment the value already in the 'counter' field by one?
PS - I'm a next-to-newbie with this