Bastien Koert wrote:
On Fri, May 22, 2009 at 4:24 PM, Dee Ayy <> wrote:

It sounds like you are wanting to "transpose" rows and columns.  But
you used the terms convert and fields, so google may not be helping

I found this:,23026,25752#msg-25752

I had seen that, I linked it in fact. I don't want to sum the data,
just list it. Transpose is a more correct word I suppose. The issue
is that the data in the value field is different, depending on the
value in the field_id field. Therefore, I want to take each of the
three data types and convert them to new fields, or columns, so that
all of the data for one product_id is on one row, instead of three.

cross tab query?

Huh? Whuzzat? I'm off to RTFM, and ty for the pointer.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to