Posted by cluthz on 05/08/07 02:44

Further details of the query was as follows.
It was PHP4/ MYsql 3 (unfortunlety).

I did not actually request all 35 fields, only about 4 of them. I needed to
do all rows as this is a one off change. Basically on a customer details we
were moving from storing the email address into the main customer details
into a separate table so that the customer can have more then one email
address stored.

In fact it has caused all sorts of other challenges which not doubt you guys
will hear about, but I fixed this problem by just rather then making it
update the new table in a sub routine which called again to a connection to
a database, I just done it within the main routine itself. Made it bigger
but as one off seems to work fine when I do this.

Really I would still expect it to work with the sub routine, and would like
to fully understand why it didn't. but I guess I'm just working with alot of
data.

Thanks

[Back to original message]