On Saturday 13 July 2002 00:34, Blaine D. Dinsmore wrote: > I'm using MySQL and I have noticed that my primary key which are > autoincrementing numbers do not sort properly when pulling the results to > the browser. They are showing consecutively all the way until 150 then they > start going backwards for example: > 157 > 156 > 155 > 154 > 159 > 160 > 161 > 162 > 163 > When I do a query in MySQL they are sequenced correctly but using the php > mysql_fetch_array() I get this crazy numbering sequence. Does anyone know > what this could be?
Use an "ORDER BY" clause to sort them in whatever order you need. -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* A pound of salt will not sweeten a single cup of tea. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php