Re: One table, multiple queries?
| From: | Still Learnin' | Date: | Mon, 01 Jun 2009 03:40:02 +0000 |
| Subject: | Re: One table, multiple queries? | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46212@lists.php.net to get a copy of this message | ||
Bastien Koert wrote:
On Fri, May 22, 2009 at 4:24 PM, Dee Ayy <dee.ayy@gmail.com> wrote: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.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
cross tab query?Huh? Whuzzat? I'm off to RTFM, and ty for the pointer. Ski