Any bright solution for my problem?

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

 



Dear Sirs,

I have a database with thousands records. And every minutes I am selecting
50 rows from that database and send some data to another web url according
sellected 50 rows.

Whenever, my script finish job in one minute, I have no problem. Because
after each transaction, I am uptading one of the rows field as a "uesd".

BUT! if my script can not finish sending data to another url due to low
speed connection or such a problem. On the next minute, same script runs
automaticlay and sellecting another 50 rows which are not marked by "used".

In this case, some times these two running acripts are sellecting same rows
due to, old one haven't marked as a "used" for sellected rows.

Is there any way, to put flag or something like that, when sellecting rows
with php and mysql?

Best Regards

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux