Michael Boudreau wrote:

> I am getting odd (to me) behavior from fetchrow and wonder if anybody 
> else is aware of this problem ...

> IF the last value (Email) in any row is an empty string, the fetchrow 
> method returns false (and any remaining rows are not processed). Very 
> bad when the *first* row in the data set happens to have a blank value 
> in the last column.

Not always obvious: fetchrow is an alias for fetchrow_array.  Read the
docs on fetchrow_array to understand what you're seeing.  Basically, in
scalar context it's driver dependent whether the first or last column is
returned.  In your case, I'd assume the last.

Try using fetchrow_arrayref and your problem will go away.

-- 
Steve Sapovits    GSI Commerce, Inc.    http://www.gsicommerce.com


Reply via email to