Can anyone see a problem with this query!
UPDATE advertiser_info SET CreditLeft = CreditLeft - 0.01, HitsReceived = HitsReceived + 1 WHERE PrimaryID = 4
No error is produced by mysql_error(), and other parts of the query are updated fine (such as (HitsReceived), but CreditLeft does not seem to get deducted!
This is in PHP BTW (relating to the mysql_error())
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
UPDATE advertiser_info SET CreditLeft = CreditLeft - 0.01, HitsReceived = HitsReceived + 1 WHERE PrimaryID = 4
No error is produced by mysql_error(), and other parts of the query are updated fine (such as (HitsReceived), but CreditLeft does not seem to get deducted!
This is in PHP BTW (relating to the mysql_error())
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!