> Unfortunately though i think we need to be able to make the changes in > something we can see which is why we are using mysqlcc.
What is the final use for the database? Is it for a website, an application, or just mere data storage? If it's either of the first two, an admin form can be built into the website or application. If you're just using the DB to store data (and not archiving it), you're making life difficult. I find a good general rule to be: if the data isn't being searched, sorted, indexed, or archived, use a flat file (like Excel). Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Daniel Crompton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, 01 June, 2003 14:00 Subject: Re: Advice on improving our current method > SET @rank:=5; > > UPDATE music SET chart=0 WHERE [EMAIL PROTECTED]; > UPDATE music SET chart=chart+1 WHERE chart<@rank; > Thanks Don Unfortunately though i think we need to be able to make the changes in something we can see which is why we are using mysqlcc. With mysqlcc any of us can simply reorder the chart by simply re-typing in all the position numbers. It is a pain typing in 1 2 3 4 5 6 etc up to 100 everyweek, but i guess this is possibly the easiest way for us to maintain the music chart. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
