Op dinsdag 30 juli 2002 05:44, schreef Georgie Casey:
> So I've 2 questions
INSERT TABLE id values('');
leave it empty
> 1) Can the next auto_increment value be 'set' by a SQL query????

> 2) Can I get a SQL query to INSERT INTO the first 'hole' it finds in the ID
> column??
I don't think so. You can mark the row, when you delete it.
Make the field mark (or you a field you already have) b.e small int (1)
In stead of deleting, you insert empty values and set mark to 1

If you insert a row, you need a extra query:
SELECT id where mark=1 SORT BY id ASC
If no row found insert with id (see above) else use the  id found;
UPDATE TABLE SET i mark='0'............. WHERE id='$first_ID_with_mark_is_1'

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to