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? 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'. Link to comment https://forums.phpfreaks.com/topic/205411-mysql-insert-help/#findComment-1074946 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.