Would using sort($result); solve the problem? I believe the default sort
order is ascending. Try using sort($result) before your while($myrow =
mysql_fetch_array($result)) statement and see if that fixes things.
I also noticed that you don't use an ORDER BY clause in your sql statement,
but if
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
Blaine,
Are you adding/deleting records? Check that your MySQL tables are defined
as type MyISAM; if they are regular ISAM table the autoincrement numbers
are reused. That was a surprise!
That may not be the problem, but I see you don't have an ORDER BY clause
in your SQL. Add one, ORDER BY
MySQL has no obligations when it comes to sorting result sets. If you want it sorted
a certain way, it'd be in your best interest to declare it with ORDER BY item_id ASC,
if that's your flavor.
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums:
... sorry for the tangent. :-)
Ryan
-Original Message-
From: Martin Clifford [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:14 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [PHP-DB] ID numbers not sorting Properly
MySQL has no obligations when