i want to change the data comming from my db every 24 hours -

i have coloum called discription with id 1 to 10 - i want the id 1 to display 24 hours then id 2 for next 24 hours and so on - how do i do that ??

suhailkaleem

You could define a date for each id. When building the recordset that contains todays id you just have to filter on DATE and then it'll contain the id you want to have.

When you want to rotate them you should find some nice math function that can count the required id depending todays date.

Also using stored procedures might be an option, but I don't know much about them.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------