Re: Authomatic Sorting
| From: | Paul Burney | Date: | Wed, 04 Jul 2001 22:18:35 +0000 |
| Subject: | Re: Authomatic Sorting | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10061@lists.php.net to get a copy of this message | ||
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/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++