Banner rotator script using image file link

I'd like a php script made that will use a standard html image tag to return a random banner from the relevant campaign. So for example, the html img tag would use ... img scr="[login to view URL]" ... and return a random image from 'campaign1'. The MOST IMPORTANT thing is that he campaign owner can show their banners with standard img html... no js or jquery, using an image file URL. ie. it must end with .jpg I'm thinking/guessing it would... 1. Have something set up globally to redirect all .jpg urls to a (php?) script... 2. That script would then make a database call to select a random banner from 'campaign1', grab the target url and update the impressions count. 3. It then returns the relevant image url in a way that will display that banner instead. I've seen this in use at [login to view URL] using php coding, but it's beyond my skills or understanding. I can handle the UI side of things and the database, but I need a coder to work out the actual image lookup and display. I'd prefer the database to be MSSQL and I'd provide an stored procedure that would just need to be executed to to retrieve the banner details. Likewise, the example above uses php, but I'm open to suggestions. This will be used on a Windows/IIS server, so hopefully it can be done with either PHP or ASP? I tried posting this on a different site, and everyone who responded either offered a standard banner exchange script or various options that pulled images from a folder or text file. So just to be clear, I need this to retrieve the relevant banner record from a database... based on an img src url, based on a campaign ID... and display the required image instead. Hoping someone is up to the challenge!