FUDforum: comp.lang.php » from mysql in associative array

Home » Imported messages » comp.lang.php » from mysql in associative array

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

Re: from mysql in associative array [message #183968 is a reply to message #183967]

Fri, 29 November 2013 15:40

tony
Messages: 19
Registered: December 2010

Karma:

Junior Member

I wrote:
> In article <l7abvs$k7s$1(at)dont-email(dot)me>,
> Knut Krueger <knut(dot)krueger(at)usa(dot)com> wrote:
>> Hi to all, whats the best was to get to get one of two colums of an
>> database query in an array as the names of the associative array
>>
>> means
>> mysql table
>> id value
>> 1 green
>> 2 red
>> 3 blue
>> ....
>>
>>
>> should be
>>
>> $array = array ( 'green ' => '1',
>> 'red ' => '2',
>> 'blue ' => '3' );
>
> I would do something like:
>
> $array = array();
>
> $sh = mysql_query("SELECT id,value FROM mytable", $db);
> if ($sh) {
> while ($ob = mysql_fetch_object($sh)) {
> $array[$ob->value] = $ob->id;
> }
> $sh->finish();

Of course, that should be mysql_free_result($sh);

That's what I get for flipping between PHP and Perl DBI !

> }
>
> Cheers
> Tony
> --
> Tony Mountifield
> Work: tony(at)softins(dot)co(dot)uk - http://www.softins.co.uk
> Play: tony(at)mountifield(dot)org - http://tony.mountifield.org

--
Tony Mountifield
Work: tony(at)softins(dot)co(dot)uk - http://www.softins.co.uk
Play: tony(at)mountifield(dot)org - http://tony.mountifield.org

Report message to a moderator

[Message index]

		from mysql in associative array By: Knut Krueger on Fri, 29 November 2013 15:31
		Re: from mysql in associative array By: tony on Fri, 29 November 2013 15:36
		Re: from mysql in associative array By: tony on Fri, 29 November 2013 15:40
		Re: from mysql in associative array By: The Natural Philosoph on Fri, 29 November 2013 16:47
		Re: from mysql in associative array By: Jerry Stuckle on Fri, 29 November 2013 19:06
		Re: from mysql in associative array By: Thomas 'PointedEars' on Fri, 29 November 2013 20:29
		Re: from mysql in associative array By: Ben Bacarisse on Fri, 29 November 2013 22:26
		Re: from mysql in associative array By: Thomas 'PointedEars' on Fri, 29 November 2013 22:36
		Re: from mysql in associative array By: Denis McMahon on Fri, 29 November 2013 23:56
		Re: from mysql in associative array By: Ben Bacarisse on Sat, 30 November 2013 00:30
		Re: from mysql in associative array By: Jerry Stuckle on Sat, 30 November 2013 01:29
		Re: from mysql in associative array By: tony on Sat, 30 November 2013 13:35
		Re: from mysql in associative array By: Thomas 'PointedEars' on Sat, 30 November 2013 14:28

Previous Topic:	Regarding split text and match from data base
Next Topic:	Review Copies Available for Learning FuelPHP for Effective PHP Development

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:54:41 GMT 2024

Total time taken to generate the page: 0.05222 seconds