ninedoors Posted September 3, 2007 Share Posted September 3, 2007 Is there a way in phpMyAdmin to set it up so when I enter a record it goes at the below the previous entered record? So that the ID is descending? I couldn't find anything on the home page about default settings. I am using phpMyAdmin - 2.10.0.2. Any help would be great. Nick Quote Link to comment Share on other sites More sharing options...
phpSensei Posted September 3, 2007 Share Posted September 3, 2007 wrong section... isnt there a little option to choose if the id is descending or ascending... although you cant order by an id... Quote Link to comment Share on other sites More sharing options...
d22552000 Posted September 3, 2007 Share Posted September 3, 2007 INSERT INTO `table` `row` AFTER `firstrow` Quote Link to comment Share on other sites More sharing options...
phpSensei Posted September 3, 2007 Share Posted September 3, 2007 yeah, but you want to order the list desc everything you enter a record into the database.. im confused. Quote Link to comment Share on other sites More sharing options...
ninedoors Posted September 3, 2007 Author Share Posted September 3, 2007 I meant to saying ascending. Looking for a default setting, not a way to do it when I'm in phpMyAdmin. Nick Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted September 3, 2007 Share Posted September 3, 2007 I meant to saying ascending. Looking for a default setting, not a way to do it when I'm in phpMyAdmin. Nick Set it to auto increment, or is that not what you mean? Quote Link to comment Share on other sites More sharing options...
ninedoors Posted September 3, 2007 Author Share Posted September 3, 2007 It is set to auto-increment, but I would like my first record entered to be at the top of the table and the last record I entered to be at the bottom of the table. Right now, it is the opposite. I didn't know if there was a way to set default settign in phpMyAdmin. Nick Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted September 3, 2007 Share Posted September 3, 2007 SELECT * FROM whatever ORDER BY id ASC But it should already be sorting the results ascending. Quote Link to comment 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.