Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #12026

Re: from mysql in associative array

Show all headers | View raw

On 11/29/2013 11:47 AM, The Natural Philosopher wrote:
> On 29/11/13 15:40, Tony Mountifield wrote:
>> I wrote:
>>> In article <l7abvs$k7s$1@dont-email.me>,
>>> Knut Krueger  <knut.krueger@usa.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 !
>>
> Tsk It uses the deprecated Mysql functions..
>
> I think if the query is 'order by id' and id is unique and you do a
> myslqli_fetch_assoc then you can get the array already parcelled up with
> red tape on.
>

You think wrong (as usual).  Other than using mysql_xxx instead of 
mysqli_xxx, Tonly's response is accurate.

Personally I would have used mysqli_fetch_assoc, but you still need to 
build the new array as Tony indicated - just using indexed entries in an 
array instead of members of an object.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

from mysql in associative array Knut Krueger <knut.krueger@usa.com> - 2013-11-29 16:31 +0100
  Re: from mysql in associative array tony@mountifield.org (Tony Mountifield) - 2013-11-29 15:36 +0000
    Re: from mysql in associative array tony@mountifield.org (Tony Mountifield) - 2013-11-29 15:40 +0000
      Re: from mysql in associative array The Natural Philosopher <tnp@invalid.invalid> - 2013-11-29 16:47 +0000
        Re: from mysql in associative array Jerry Stuckle <jstucklex@attglobal.net> - 2013-11-29 14:06 -0500
      Re: from mysql in associative array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-11-29 21:29 +0100
        Re: from mysql in associative array Ben Bacarisse <ben.usenet@bsb.me.uk> - 2013-11-29 22:26 +0000
          Re: from mysql in associative array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-11-29 23:36 +0100
          Re: from mysql in associative array Denis McMahon <denismfmcmahon@gmail.com> - 2013-11-29 23:56 +0000
            Re: from mysql in associative array Ben Bacarisse <ben.usenet@bsb.me.uk> - 2013-11-30 00:30 +0000
          Re: from mysql in associative array Jerry Stuckle <jstucklex@attglobal.net> - 2013-11-29 20:29 -0500
        Re: from mysql in associative array tony@mountifield.org (Tony Mountifield) - 2013-11-30 13:35 +0000
          Re: from mysql in associative array Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-11-30 15:28 +0100

csiph-web