database fault

[morningstar]

hey,

I need to resolve something but i dont know how, i explain.
lets imagine i have a database table like this:

id -- name -- etc
1 -- name1 -- etc1
2 -- name2 -- etc2

id = int, auto increment, primary key

now i use a command to delete the id = 1 row.
now i add a new row in the table and the database will give it id = 3 instead of the deleted one id = 1..

how can i prevent the problem that it let open spaces in the id column?

[goldlikesnow]

As you defined the column auto_increment it will just do that.

You could do a INSERT...... ON DUPLICATE KEY UPDATE SQL command (>= MySQL 4.1) or turn auto_increment off and generate your own if necessary

[morningstar]

ok thanx,

i will try to do something with the "ON DUPLICATE KEY UPDATE" function since i have a later version of php 4.1 🙂