Mysql

[hari4php]

Hi,
i am working on a table which has the two fields id and daily_message,Around 100 records are there,
The thing is only one message should be displayed as per the order of the records.

I am working on the query but cant get the desired result,
The timing of the execution of the query can be done through CRON, but the query is not working.
The table has just two fields: ID and daily_message

Some sample values

ID daily_message

---

1 Sample message1
2 sample message2

Record one should be displayed on first day,After 24 hrs the next message should be displayed in plcae of first message.

Regards
Hari.V

[djjjozsi]

Cron job can update your table and set the actual ID into inactive, and the ID+1 into active.