I am using mysql 5.0.51a with php 5.2.5
I am using the insert command to enter data.
It keeps inserting data in random locations in the table, which is messing up my web app.
It did use an id column at one time.
I've tried flushing the table, and remaking the table with phpmyadmin's sql dump.
How can I fix this? I just want mysql to insert data at the end of the table, like it should.
There is no intrinsic ordering to the data. None of the default storage engines guarantee data will be stored in insertion order. You have to order by some column if you want it sorted.
fix your web app, because the database is behaving exactly as it should