Hello,
I vaguely remember reading in the manual that the order of the retrieved rows in a response to a select statement is unpredictable (unless you use an order by clause). this possibly depends on the indices set up for the table and/or used in constructing the result etc. is this accurate? if so is there any way to insure that rows retrieved are returning in the order by were inserted in, say other than ordering by some 'insertion counter' (such a counter is of no use otherwise in my application!). thanks for the help. -- Murad Nayal M.D. Ph.D. Department of Biochemistry and Molecular Biophysics College of Physicians and Surgeons of Columbia University 630 West 168th Street. New York, NY 10032 Tel: 212-305-6884 Fax: 212-305-6926 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]