> On Sat, 2003-02-01 at 17:25, John W. Holmes wrote: > > > I'm loading a .csv file into MySQL, done it a million times but for > > some > > > reason it is scrambling the row order. All the fields are making it in > > > correctly but the order of the rows seems to end up totally random. > > I've > > > done this a million times and never saw this.. > > > > So? > > > > Why does it matter to you what order the rows are in the database, as > > long as the right data is there? The order is irrelevant. > > > > Because in this instance I need it to come out in the order it is > actually in.
Then use an ORDER BY in your query. If you're relying on the database to spit out rows in the order they went in, then you're wrong. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php