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 #183967 is a reply to message #183966]

Fri, 29 November 2013 15:36

tony
Messages: 19
Registered: December 2010

Karma:

Junior Member

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();
}

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

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 Nov 22 03:36:51 GMT 2024

Total time taken to generate the page: 0.04073 seconds