> >> I think we are almost there. This code is not producing an error,
but
> >> it is also not incrementing the database. The value stays at zero.
Any
> >> idea what could be wrong?
> >>
> >> $inc_current_ad = WrapMySQLDatabaseResults("macasap", "update ads
> > where
> >> ad_id = ".$current_ad->Value("ad_id")." set
> >> rotate=".($current_ad->Value("rotate")+1),
> > "block=0","inc_current_ad");
> >
> > Are you sure $current_ad->Value("rotate") is returning a value?
>
> Yes it is.
>
> > If you're just trying to increment "rotate" by one, then you can use
> > Update ... set rotate = rotate + 1 where ...
>
> Could you give me the full SQL statement?
Wait a minute... is that your right SQL up there? If so, your update is
out of order. Wouldn't you want this:
"update ads set rotate=".($current_ad->Value("rotate")+1)." where
ad_id = " . $current_ad->Value("ad_id")
or just
"update ads set rotate = rotate + 1 where ads_id = " .
$current->Value("ad_id")
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
