mysql> select * from skunk;
+----+--------+--------+--------+
| id | valueA | valueB | valueC |
+----+--------+--------+--------+
| 1 | A      | 0      | 0      |
| 1 | 0      | B      | 0      |
| 1 | 0      | 0      | C      |
| 2 | E      | 0      | 0      |
| 2 | 0      | F      | 0      |
| 2 | 0      | 0      | G      |
+----+--------+--------+--------+
6 rows in set (0.00 sec)

mysql> select id, max(valueA), max(valueB), max(valueC) from skunk group by id;
+----+-------------+-------------+-------------+
| id | max(valueA) | max(valueB) | max(valueC) |
+----+-------------+-------------+-------------+
| 1 | A           | B           | C           |
| 2 | E           | F           | G           |
+----+-------------+-------------+-------------+
2 rows in set (0.00 sec)

mysql>

From: mainakibui@gmail.com
Date: Wed, 7 Nov 2012 11:40:22 +0300
To: skunkworks@lists.my.co.ke
Subject: Re: [Skunkworks] SQL Help

Use arrays

<?php

<Solution> create a multidimensional array </Solution>

<Author> @mainakibui </Author>

$OurWebsites = array(www.360tours.co.ke, www.anza.co.ke);

/*Begin by creating a multidimensional array from your query result*/

$queryResult=array(1=>array(array(A,0,0),array(0,B,0),array(0,0,C)),2=>array(array(E,0,0),array(0,F,0),array(0,0,G)));

echo " View Your multidimensional array ";

/*what you have*/

foreach ($queryResult as $values):

foreach ($values as $value=>$result):

print_r($result);

echo " ";

endforeach;

echo " ";

/*Create a new multidimensional array*/

foreach ($queryResult as $xvalue=>$values):

foreach ($values as $results):

foreach($results as $nvalue=>$result):

if($result != '0'):

$newarray[$xvalue][$nvalue]=$result;

endif;

endforeach;

echo " Your final resulting array ";

/*This will give you (You can)*/

foreach($newarray as $value=>$array):

echo $value." ";

print_r($newarray[$value]);

echo " ";

endforeach;

Rgds,
Kibui Kenneth Maina,

T: +254 (0) 721 173 780 W: Opticom Solutions B: kit-b.com T: @mainakibui S: kenneth.kibui Q: Quora

Tools I Use:

PHP, Javascript, JQuery, MYSQL, SQLite, Android app dev, Joomla, Amazon cloud hosting, WHM, Cpanel, Adobe CS2-5, Dreamweaver, OSx, Ubuntu, Cent OS, Linux, Windows, Networking, Hardware, VM Ware.

On Wed, Nov 7, 2012 at 10:07 AM, julianne anyim <julianneanyim@gmail.com> wrote:

Hello,

I have a query that generates records in this form.

1   A   0   0
1   0 B 0
1   0    0 C
2   E 0   0
2   0 F 0
2   0    0 G

I want the records in the following format.

1 A B C
2 E F G

The query doesn't have an aggregate function (eg SUM, COUNT etc) so i can't GROUP BY.

Anyone please :)

Regards,

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke

_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke