Bastien Koert wrote:
On Fri, May 22, 2009 at 4:24 PM, Dee Ayy <dee.ayy@xxxxxxxxx> 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
you.
I found this:
http://forums.mysql.com/read.php?86,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.
Ski
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
