Re: Selecting next ID and less?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes, I thought of doing that. I'm thinking a better solution (if nothing better can be found...) would be to store a hand-incremented number seperatley.

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux