I've noticed that when I add a row it doesnt increment the id field properly. I first noticed this when I deleted rows then tried to add rows, the added rows id would increment from the highest id of a deleted row.

So how would I increment an id column from the last row thats in the table?.

As long as the Id column is auto_increment, when you do your insert statement, it should look something like this:

PHP Code:

mysql_query("INSERT INTO users (username, firstName, lastName) VALUES ('kbailey', 'Kyle', 'Bailey')"); 


just make sure you specify which columns you want teh information to be added to where username, firstname, lastname is, and the values correspond to those tables in that order, and that will increment the Id field automatically.

Here's a quick example/reference for using AUTO_INCREMENT:

http://dev.mysql.com/doc/refman/5.0/...increment.html

Thanks