Mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hari4php
Forum Newbie
Posts: 5
Joined: Wed Mar 03, 2010 11:07 pm

Mysql

Post by 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Mysql

Post by Christopher »

Show us the SQL you are using.
(#10850)
Post Reply