Except don't use the word "Order" as a table column name. It's a reserved sql word. Cheers Dave T
-----Original Message----- From: Super Steve [mailto:[email protected]] Sent: Tuesday, 1 December 2009 10:49 a.m. To: NZ PHP Users Group Subject: [phpug] Re: Rotating Items on a Daily Basis? Hey that sounds like a great way to do it. Thanks Simon! On Dec 1, 10:13 am, Simon J Welsh <[email protected]> wrote: > One way would be to add a column to the table, say Order, with values from 1 > to max. Then, using a crontab or some such, UPDATE Stores SET Order = Order - > 1; UPDATE Stores Set Order = MAX(Order) + 1 WHERE Order = 0; > > Grab the stores sorted by Order. > > On 1/12/2009, at 10:09 AM, Super Steve wrote: > > > > > > > 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] > > --- > Simon Welsh > Admin ofhttp://simon.geek.nz/ > > Who said Microsoft never created a bug-free program? The blue screen never, > ever crashes! > > http://www.thinkgeek.com/brain/gimme.cgi?wid=81d520e5e -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] Warning: This email contains information which is CONFIDENTIAL and may also be LEGALLY PRIVILEGED. If you are not the intended recipient you must not peruse, use, disseminate, distribute or copy this email or attachments. If you have received this in error, please notify us immediately by return email and delete this email. Thank you. ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ##################################################################################### -- NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected]
