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 Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/ 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... Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340672 Share on other sites More sharing options...
d22552000 Posted September 3, 2007 Share Posted September 3, 2007 INSERT INTO `table` `row` AFTER `firstrow` Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340673 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. Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340677 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 Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340679 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? Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340680 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 Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340685 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. Link to comment https://forums.phpfreaks.com/topic/67796-solved-phpmyadmin-question/#findComment-340690 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.