I have a primary key listed as ID
When I first added about 10 records and then deleted a few records and
then added more records it didn't replace the missing records.
When I select all records to view I now get:
1
2 why didn't it go to 3, 4 and 5 after 2?
6
7
8
When I add a record it becomes record 11. Am I doing something wrong
when I delete a record? I thought it would move the other records down
6 and 7 would be 3 and 4 etc...
Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7
php-mysql-4.0.4pl1-3
mysql-devel-3.23.32-1.7
mysqlclient9-3.23.22-3
mysql-3.23.32-1.7
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php