Re: Authomatic Sorting

D you ever create an index on the primary key to speed things up?? ken ----- Original Message ----- From: "Paul Burney" <burney@gseis.ucla.edu> To: "Wilmar Pérez" <wilmar.perez@caribe.udea.edu.co>; "PHP List" <php-db@lists.php.net> Sent: Wednesday, July 04, 2001 3:18 PM Subject: Re: [PHP-DB] Authomatic Sorting on 7/4/01 1:50 PM, Wilmar Pérez at wilmar.perez@caribe.udea.edu.co wrote: > I've got a table with an autoincrement field which is the registry's ID, > everything goes well until I delete any registry. MySQL doesn't re-sorts > the information. That is, I have the following: <snip> Just add an "ORDER BY" clause to your query. That is, if you want to sort by reg_id, append "ORDER BY reg_id". You can also add a DESC keyword to put them in reverse order. HTH. Sincerely, Paul Burney ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Paul Burney Webmaster && Open Source Developer UCLA -> GSE&IS -> ETU (310) 825-8365 <webmaster@gseis.ucla.edu> <http://www.gseis.ucla.edu/> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net