I've got a client that wants to display on his website a list of retail stores that stock his products. To facilitate this we have all of the store details in a MySQL database.
But rather than display all of the stores in alphabetical or location order, my client wants to rotate the stores so each one gets a turn at being at the top. The idea is that at the beginning of each day the store that was on the top yesterday will move to the bottom and all the other stores move up one. For the rest of the day the stores are displayed in this order, i.e they maintain their positions for the whole day. Then next day the top one goes to the bottom and they all move up one. Does anyone have any idea on how I can achieve this? I'm not looking for actual PHP code, just pseudo code to get me on the right track. -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
