stowell Posted August 26, 2006 Share Posted August 26, 2006 Hi Guys, Can someone help me? I have a table name messages column "msg_id,msg_name and msg_description this table have 72 data, I want this data to view one at the time ramdomly every 5 hours in a web page.Thanks Quote Link to comment Share on other sites More sharing options...
shocker-z Posted August 26, 2006 Share Posted August 26, 2006 $query = "SELECT msg_id,msg_name, msg_description FROM `table_name` ORDER BY RAND() LIMIT 0,1";thats a query that will select a record at random but that 5 minutes u will need to refresh the page as php is server side so can't time and update dynamicaly or a less in a iframe or using AJAXRegardsLiam Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.