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? > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
