Rotating adds

[chrab]

I have a page where I load pics on the site and in a access db table i have where each one is located and the corr. link. I have those adds displayed on the asp page and what i want to know is if there is a good way to rotate the adds every so often. I thought about giving each entry an number and some how updating the records automatically but im not sure how to send a trigger throug the web page. any thoughts

 

[DotNetGnat]

lot of examples here

-DNG

 

[Sheco]

You could give each one a time of day...[tt]

AName ATime
------- -------
First 9am
Second 6pm
Third 2am[/tt]

... and then use some query like this:[tt]
SELECT Min(AName) FROM MyTable WHERE Now() >= ATime[/tt]