| Re: from mysql in associative array [message #183970 is a reply to message #183969] |
Fri, 29 November 2013 19:06   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
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(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 !
>>
> 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(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]