ot; ...
DEVELOPER: "You picked the tool, we just do our best to support it." ...
Anyway... 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 PROT
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: http://www.completesourc
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
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 backw
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 th
