How about flag the tip record with a bit field called 'live'. Then you can
see the tip that's "live", and then take the next tip in whatever order you
have them.

Greg

-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 10:11 PM
To: CF-Talk
Subject: RE: Daily Tip help...

why not put them in a database, with a  sort order, and whatever day of
the month it is, show that based on the sort order numbered from 1-28 or
something like that? or just do it randomly.  where each page refresh
would show a new one?

....tony

Tony Weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
410.548.2337
www.navtrak.net

-----Original Message-----
From: Bailey, Neal [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 9:51 PM
To: CF-Talk
Subject: Daily Tip help...

Hello All...

I am having an issue with trying to build a rotating daily tips script.
All I want to do is have a database full of tips and everyday have a new
tip display on the front page. I thought it was easy but for some reason
I cannot get it to work. I have about 40 tips so all it needs to do is
select the next record everyday. Can someone point me in the right
direction... I have looked all over the net for examples but oddly
enough there are not any that do such a simple thing, at least that I
could find.

Thanks for any help on this I'm sure its simple, but for some reason I
cant figure it out.

- Neal
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to