Problem with inserting information

[SomeHorse]

I have a form set up that allows people to enter information and it is supposed to place it in the database that I have set up. Strangely though, it rarely adds the information at the end of the database but in random places (such as between rows 4 and 5 while it should be entered after the last row in the database) What is causing this and what can I do to make sure all information is added at the END of the database and not in random places?

This wouldn't be such a problem but each row of information has a identification number that I assign (such as 0024) so that I can keep track of it all... but with it adding it where it does, I get 0023, 0101, 0024. Very annoying!

Someone suggested using auto_increment but I keep getting this message no matter what combination I put in for the column

Incorrect column specifier for column 'idnumber'

Any help is welcome! Thanks!

 

[r937]

relational databases do not store rows in any particular order

if you want to see the rows in a particular order, you have to use ORDER BY when you SELECT

that's all there is to it


rudy

http://r937.com/