|
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?
Navigation:
[Reply to this message]
|