Re^2: database not in correct order

The sort is done by the primary key ID. The time is entered in as 0:0:0 because I originally didn't store time in my original DB_File database but I'm going to start recording it now.

Comment on Re^2: database not in correct order

Replies are listed 'Best First'.
Re^3: database not in correct order by dws (Chancellor) on Nov 27, 2007 at 05:42 UTC
The sort is done by the primary key ID. Assuming that you created the table with `... id int auto_increment, primary key (id), ...` [download] and you don't specify an `ORDER BY` clause for something other than `id`, you should get the records back in the order you put them in. Is it possible you forgot the `auto_increment`?	[reply] [d/l] [select]