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. 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; ;) ;) 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! 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
Archived
This topic is now archived and is closed to further replies.