Implement a queue with a table - how?

[Johan Sandgren]

Hi,

I'm using a table as a queue, and recently came upon some problems.

Firstly, the table was detecting duplicate error when trying to insert.
It was the auto_increment-key had somehow reached it's maximum value and did not wrap around to 0 again. I would like it to if possible...

Any ideas of how to handle this?

(Of course, when the key wraps around, I need to keep remembering the position where the queue starts, since sorting the posts will not anymore give the first post if sorting on the key).

Greetings,

Johan