c_pattle Posted June 21, 2010 Share Posted June 21, 2010 I have a table in my database with a long list of products, all of which have an id number which is the primary key and auto increments. When I insert a new product into the table it adds it at the end of the table. Is there a way I can insert it at the front of the table and it will move all the other products down and increase their id by 1? Quote Link to comment https://forums.phpfreaks.com/topic/205411-mysql-insert-help/ Share on other sites More sharing options...
trq Posted June 21, 2010 Share Posted June 21, 2010 You shouldn't be relying on the primary key to determine the display order of your data, create another column and sort by that. Either that, or simply select and dsiplay your data using 'ORDER BY id DESC'. Quote Link to comment https://forums.phpfreaks.com/topic/205411-mysql-insert-help/#findComment-1074946 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.