> 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]
