PHP Programming - Re: Query and Synchronization...

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Query and Synchronization...

Giovanni

2007-04-26, 7:58 am

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?

Sponsored Links