MySQL Forums
Forum List  »  Newbie

rand() to randomize rows only once daily
Posted by: Ryan Bauer
Date: January 29, 2010 03:24PM

My question is it possible to randomize the sort order of a mysql result only once per day using the RAND() or some other function???.

background:

I had a client today that has a website that list happy hour specials for the day the specials change every day at midnight to the next days specials. the problem is that they only have room to list 22 specials but some days have more specials then their are space. The client does not want to add more listings but rater randomize the listing for each day. The one problem is they do not want the listing the change their postions / order on each click but instead randomize the oerder only once daily so the specials on monday of this week will be different from the specials next monday.




Thank you for your help
Ryan Bauer

Options: ReplyQuote


Subject
Written By
Posted
rand() to randomize rows only once daily
January 29, 2010 03:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.