Posted by Giovanni on 04/26/07 09:22

That's the situation... I've to grant round robin algho in a small
number of records i.e. 20...
The operations are theese:
MYSQL->select id,ticket
PHP-> search ticket=true
MYSQL-> SET ticket=false with id=ID
MYSQL-> SET ticket=true with id=nextticket_at_id();

semaphore could help me?

I was thinking to change strategy...
I wisha use datetime type to retrieve the oldest record not retrieved,
and so update it with NOW()
selecting the record in age order and limiting to 1 i could have what
I want...
dont'you think?

[Back to original message]