On 12/30/05, Richard Lynch <ceo@xxxxxxxxx> wrote: > The suggestions so far are good, but watch out for this: > > If you do one record at a time, and are using LIMIT, and then > something gets inserted into the original table... > > Boom! You could always lock the tables whilst performing the update - not very useful if the database has to be up all the time but it's probably the safest way of doing it. Paul -- Data Circle http://datacircle.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php