Chikenty Posted October 25, 2007 Share Posted October 25, 2007 Hi, ive been trying to make a random mysql result grabber which i have done. But what id like to do is have it stick around for awhile. So i was wondering how i can give it a specific time and after that time it will grab another result. Any help or pointing me in the right direction would be gladly appreciated. Thanks Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted October 25, 2007 Share Posted October 25, 2007 Thats quite vague. What are you actually trying to achieve? If you are pulling something from you database (a link to an image say) which is random, but you want it to only change after 5 minutes or so, then you could use sessions: store the time the image was last changed in a session, and if this is greater than 5 minutes, load a new random image and update the time. Of course, this would mean the images are different for different people on your site, but since i don't actually know what you are tying to achieve, that might not be a problem. Quote Link to comment Share on other sites More sharing options...
Chikenty Posted October 25, 2007 Author Share Posted October 25, 2007 Yea sorry i just been busy and got bunch of things i still need to do today. Pretty much all im doing is have a random member being pulled from the database(username and all that junk) and be displayed. But i want it to b like member of the week. Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted October 25, 2007 Share Posted October 25, 2007 Using a cron job would be the easiest thing - set a script to run once a week to determine who is 'member of the week' and store that member's id in a database. 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.