Making a new ID for a new field?

[Inkybro]

I've been doing:

$nr = mysql_num_rows($q1);
$newid =  $nr + 1;

But when/if I delete a field from the DB and use the code again itll count the rows and add one, but that leaves you with two of the last number (i.e. two 30s).

What I WANT to do is find the last row entered and add 1 to it's ID but I don't know the query to do something like that, any help appreciated!

[Shrike]

Give the id column an auto_increment attribute:
http://www.mysql.com/doc/en/ALTER_TABLE.html