SELECT * FROM Banners Where Bannerid = #Bannerid# SELECT max(ViewID) as tot FROM tblStats WHERE (BannerID=#bannerid#) AND (AffiliateID=#Affiliateid#) SELECT Impressions FROM tblStats WHERE viewid = #getview.tot# SELECT total FROM tblRefs WHERE refname = '#ReferSite#' or refname = '#ReferIP#' INSERT INTO tblSTATS(BannerID, affiliateid,Impressions,clickdatetime) VALUES (#BannerID#,#affiliateid#,1,'#dateFormat('#now()#','mm/dd/yyyy')#') INSERT INTO tblRefs(RefName) VALUES ('#ReferSite#') UPDATE tblStats SET impressions = #add_imp# WHERE viewid = #getview.tot# INSERT INTO tblRefs(RefName) VALUES ('#ReferIP#') INSERT INTO tblRefs(RefName) VALUES ('#ReferSite#') UPDATE tblRefs SET total = #add_imp# WHERE refname ='#ReferIP#' UPDATE tblRefs SET total = #add_imp# WHERE refname ='#ReferSite#'