SELECT url, adid FROM adsystem WHERE adid = #url.adid# SELECT adid, total, stamp, type FROM adlog WHERE datediff(dd,stamp,getdate()) = 0 AND adid = #banner_info.adid# AND type = 2 INSERT INTO adlog(adid,stamp,type,total) VALUES(#banner_info.adid#,getdate(),2,1) UPDATE adlog SET total = #IncrementValue(checklog.total)# WHERE datediff(dd,stamp,getdate()) = 0 AND adid = #checklog.adid# AND type = #checklog.type#