PHP with MySQL Question
Posted: Sun Feb 15, 2009 10:02 pm
Hello, I am making a PHP website, and I have it input information into a MySQL Database. I have one question about this though, how can I, if possible, while the information is being put into the MySQL Database, it looks at the first column, and there is a ID column, which changes for every new entry, I drew up some pictures to help explain what I am trying to describe, any help is greatly appreciated! Thanks a bunch!
| This is the normal php page, which has input boxes
|
\/

This is in the MySQL Database, and see the ID 1? which is in the ID column? |when there is a new entry, the ID would be +1, which would be 2, and the third one down would be 3, basically add 1 to the last ID in the table... So in other words, it will find look at the last column, and the last ID number, and add 1 to it, and insert the next number on the next line down!
\/

-FlightFanatic
| This is the normal php page, which has input boxes
|
\/

This is in the MySQL Database, and see the ID 1? which is in the ID column? |when there is a new entry, the ID would be +1, which would be 2, and the third one down would be 3, basically add 1 to the last ID in the table... So in other words, it will find look at the last column, and the last ID number, and add 1 to it, and insert the next number on the next line down!
\/

-FlightFanatic