I'd like to be able to display a message that will start running on certain date and expire on some specified date. I can create a table and have start and end date as well as message columns. How do I go about the actual script that will do the job? Any suggestions?
you select the messages relevant for the current time period when running the page. I will only display the relevant information.
🙂
OK, maybe I wasn't very clear. I need a message to run for several days, say between April 12 and May 3rd. How do i do that? Example code would be highly appreciated.
SELECT message WHERE displaydate BETWEEN '20030412' AND '20040503'
use a normal loop on results to display the results
Thanks! I'll try that.
What do you mean
"USE NORMAL LOOP"
I am on the right forum, am I... 🙂
hehe try looking in this mysql manual entry [MAN]mysql_fetch_array[/MAN]
If I am going too fast or asuming too many prerequisites, stop me and we'll go over it slowly 🙂
