auto-incrementing problem

[immanuelx2]

When i delete an entry in a table (say ID 24) and then add a new one, it will make it 25 instead of 24... is there any way (with or without myphpadmin) that it can start auto-incrementing from the lowest unused ID number?

[cgraz]

nope, that's the way the database you're using works. But it really doesn't matter what the id is in the database, as long as it's unique. It's just a reference to that row.

Cgraz

[Mordecai]

Auto-incrementing, no. As for manual incrementing, yes:

$result = mysql_query("SELECT id FROM users ORDER BY id DESC LIMIT 0,1") or die(mysql_error());
while ($user = mysql_fetch_array($result,MYSQL_NUM)) {
  $id = $user[0] +1;
}

Then use $id when you put it in the next query.