PaintBall.com: 'Guns and Gear

Insert INTO AdTrak ( AdID, CPC, IP ) VALUES ( #url.a#, #url.b#, '#cgi.REMOTE_ADDR#') SELECT PartnerName, bio_text, bio_image, url FROM Partners WHERE PartnerID = #URL.MFGid# SELECT Partners.PartnerID, Partners.PartnerName, Partners.Logo, ReviewItem.name, ReviewItem.ID, [Section].SectionName, [Section].SectionID, Partners.bio_text, Partners.bio_image FROM Partners INNER JOIN ReviewItem ON Partners.PartnerID = ReviewItem.MFG INNER JOIN [Section] ON ReviewItem.SectionID = [Section].SectionID WHERE (ReviewItem.MFG = #URL.MFGid#) and reviewitem.archive <> 1 ORDER BY [Section].SectionID, ReviewItem.name

#getmfgbio.PartnerName#:

#getmfgbio.bio_text#

#getmfgsection.PartnerName#

#SectionName#

#Name#, #Name#