FUDforum: comp.lang.php » Roll SQL name value query into two-dimensional array

Home » Imported messages » comp.lang.php » Roll SQL name value query into two-dimensional array

Show: Today's Messages :: Polls :: Message Navigator

Re: Roll SQL name value query into two-dimensional array [message #175201 is a reply to message #175199]

Mon, 22 August 2011 02:50

Peter H. Coffin
Messages: 245
Registered: September 2010

Karma:

Senior Member

On Sun, 21 Aug 2011 18:35:52 -0700 (PDT), Richard A. DeVenezia wrote:
> I have a query that returns name value pairs in groups.
>
> data
> g n v
> 1 a 1
> 1 b 2
> 1 c 3
> 3 a 10
> 3 b 9
> 3 c 8
>
> want
> x[0] = array('a'=>1,'b'=>2,'c'=>3);
> x[1] = array('a'=>10,'b'=>9,'c'=>8);
>
> this is close but x is ending up empty
>
> $q = 'select g,n,v from some_view order by g,some_seq_id';
> $result = db_query($q); // in drupal
>
> $x=array();
> $map=array();
> $prior_g = -1;
> while ($obj = db_fetch_object($result)) {
> if ($rec->g != $prior_g) {
> //append a new map
> $map=$array();

So you create an empty array...

> $x[] = $map;

And tuck that into your array of objects...

> $prior_g = $rec->g;
> }

and throw away $obj ?

> // fill in the map as we roll through the name value pairs within
> the group
> $map[$rec->n] = $rec->v;
> }
>
> print "<pre>".print_r($x,1)."</pre>";
>
> shows
> Array
> (
> [0] => Array
> (
> )
>
> [1] => Array
> (
> )
> )
>
>
> So what is going wrong ?

--
For their next act, they'll no doubt be buying a firewall running under
NT, which makes about as much sense as building a prison out of
meringue.
-- Tanuki

Report message to a moderator

[Message index]

		Roll SQL name value query into two-dimensional array By: Richard A. DeVenezia on Mon, 22 August 2011 01:35
		Re: Roll SQL name value query into two-dimensional array By: Jerry Stuckle on Mon, 22 August 2011 02:15
		Re: Roll SQL name value query into two-dimensional array By: Peter H. Coffin on Mon, 22 August 2011 02:50
		Re: Roll SQL name value query into two-dimensional array By: Jonathan Stein on Mon, 22 August 2011 12:21

Previous Topic:	MySQL date time current time diffenece
Next Topic:	different servers, different results with a file upload

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:35:23 GMT 2024

Total time taken to generate the page: 0.04621 seconds