SELECT * from excessDL WHERE MID = #SESSION.MID# AND softwareDL = #sgno# INSERT INTO studyGuideIP(studyguideno,UserIP,UserHost,UserAgent,CFTok) VALUES(#sgno#,'#UserIP#','#UserHost#','#UserAgent#','#CFTok#') SELECT sgid,DLDate,StudyGuideNo,DLCount from studyGuides Where DLDate = #new_date# AND StudyGuideNo = #sgno# UPDATE studyGuides SET DLCount = #NewDLCount# Where sgid = #checkdate.sgid# INSERT INTO studyGuides(studyguideno,sgname) VALUES(#sgno#,'#sgname#') INSERT INTO MemberDownloads(MID,SoftwareDL,DLDate) VALUES(#SESSION.MID#,#sgno#,'#NDLDate#')