Please see if you can solve this problem as its driving me crazy..its for a
small affiliate program.
I have a table with the folling structure:
** table stats(Id bigint,Month tinyint,Year int,Hits bigint)
The client will be given a link like this
then this will execute in the script (the connection part is done)
** update table stats set hits=hits+1 where Id=$Id and MONTH(now())=Month
/*The logic in the above is that I am updating "hits" by one only if "month"
and "Year" match up, so I can track which affiliate has given me the most
traffic, just 12 records for each client per year and excellient dynamic
but if the fields "Month" or "Year" do not match the update will not work
and will not return anything right? so I want to execute this SQL then
** insert into stats values($Id,MONTH(now()),YEAR(CURRENT_DATE),1)
Either i'm brain dead,tired,dumb,just overworked, or this one great
problem....but I cant figure it out......
Any help appreciated, thanks in advance.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php