heilo wrote:
Hi!
This problem seems to be similar to Raymond Lilleødegård's problem (subject of the emails: Inserting data without a reference in the row.)
I suggest to add another column holding the number of the puzzles. Everytime you delete a puzzle or change something in the db you have to update this column to sustain the integrity of the numbers so that no holes come into existance (as you said it - it is not very good, that the primary key is more than a unique identifier, which should be his single job).
Unfortunately it is not possible to add a second auto_increment so the moment you create this table you have to write a small proggie which numbers the rows...
Hope this helps?
.ma
Leif K-Brooks <eurleif@buyer-brokerage.com> wrote@22.04.2003 21:55 Uhr:
I'm working on a puzzle game, where users must solve many different puzzles. Once they complete a puzzle, they will be able to try the next puzzle. Each puzzle is stored as a row in the puzzle in a database table. The problem is, how would I select the puzzles the next highest puzzle and lower? I could use a query something like "select * from puzzles where id <= $completedid + 1", but it would break is there were any holes in the ID. Also, it would use the ID as something more than a unique identifier for each row, which is a bad thing. Any suggestions for a better way?
-- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
