<?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