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 Link to comment https://forums.phpfreaks.com/topic/74724-random-mysql-result/ 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. Link to comment https://forums.phpfreaks.com/topic/74724-random-mysql-result/#findComment-377756 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. Link to comment https://forums.phpfreaks.com/topic/74724-random-mysql-result/#findComment-377762 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. Link to comment https://forums.phpfreaks.com/topic/74724-random-mysql-result/#findComment-377768 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.