Tom Hart wrote:
>
> It turns out that for some reason it didn't like to UPDATE when I was
> using a text type field (specifically an empty text field) in the WHERE
> clause. To remedy this, I instructed PHP to not use a field in the WHERE
> clause if the destination type was 'text', and now we're working
> beautifully (2.405 seconds to run the script through 1566 rows, running
> updates on 1563 of them). Now I just need to figure out what's going on
> with those 3 rogue rows.
Its almost certainly not an empty text field, but a NULL one, see Jeff's
reply to your original message.
--
Richard Huxton
Archonet Ltd