FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » from mysql in associative array
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: from mysql in associative array [message #183967 is a reply to message #183966] Fri, 29 November 2013 15:36 Go to previous messageGo to previous message
tony is currently offline  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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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) ] [ RSS ]

Current Time: Sun Nov 10 04:02:30 GMT 2024

Total time taken to generate the page: 0.04150 seconds