Yes it is a strange question.. MySQL result sets are in the order you asked in the query. IF you would like the result set to be in order by a field called ID then just add "order by ID" at the end of your query.. Is this what you were asking? If not , can you give more insights of what the query was returning before the deletion, and what it is returning now and what you'd like it to return? Thanks,
Gurhan -----Original Message----- From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 12:23 AM To: mysql lists.mysql.com Subject: ID order... Ok, strange question. I have delete some records and I have notice that ID's are no longer in order when I do a SQL statement. Why is that? What can I do put the records back into order? ---------------------------- | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | ---------------------------- BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. "Never be bullied into silence. Never allow yourself to be made a victim. Accept no one's definition of your life; define yourself."- Harvey Fierstein --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php