ess14 Posted April 2, 2008 Share Posted April 2, 2008 Well im using PHP and MySQL and i have a table like so(for example purposes): NAME ORDER john 1 greg 2 benny 3 don 4 If i delete the row GREG, what is the best way to get the order to stay in sequence. ie: Benny's order should now be 2 and dons should be 3 This way the order will have no gaps in the sequnce. imagine theres 30 rows too! so i cant really update EVERY row one by one...can i? should i? thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/99131-solved-re-ordering-a-database/ Share on other sites More sharing options...
ansarka Posted April 2, 2008 Share Posted April 2, 2008 delete from test where order=2; update test set order=order-1 where order >2; ;) ;) Quote Link to comment https://forums.phpfreaks.com/topic/99131-solved-re-ordering-a-database/#findComment-507191 Share on other sites More sharing options...
ess14 Posted April 2, 2008 Author Share Posted April 2, 2008 haha, thanks!! thats cool, learn something new every day! Quote Link to comment https://forums.phpfreaks.com/topic/99131-solved-re-ordering-a-database/#findComment-507196 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.