PHP / MySQL Associative Multidimensional Array:

Posted on 16th Feb 2014 07:03 pm by admin

Hello.

I have data in a MySQL Table that adheres to the below: (note, no index, could add if necessary)

group~~~~~setting~~~~~value
1~~~~~~~~~Babble~~~~~Yeah, sure
1~~~~~~~~~Dabble~~~~~No, rather not
2~~~~~~~~~Crab~~~~~~~Maybe
3~~~~~~~~~Flab~~~~~~~Nah, not today

I want to query this and add it to an associative multidimensional array.

I have the following:

Line number On/Off | Expand/Contract $getem = array(array()); while ($row = mysql_fetch_assoc($result)) { $getem[][] = $row['group']; $getem[][] = $row['setting']; $getem[][] = $row['value']; }


Of course, this is not associative. I thought if I changed $getem = array(array()); to $getem = array( array('group', 'setting', 'value') );, then it would be associative, but this isn't working.

My ultimate goal is this:

I have a second table in which the 'group' of the above table is a FK to the index of the second table. The end result, once processed and matched using PHP, is to print out the following:

Group Name 1
~~~Babble~~~Year, sure
~~~Dabble~~~No, rather not
Group Name 2
~~~Crab~~~~Maybe
Group Name 3
~~~Flab~~~~Nah, not today

Am I on the right track? You don't need to write the code for me, I'm just looking for a little direction.

Thanks

Your Answer:

Login to answer

Other forums

=> and <=
So I was digging through some code when I came across the <= operator. This is the first tim

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Printer configuration
Hi All,
Suppose one of the user deleted the printer settings unfortunatly ,then what is the pro

BIG file upload!
Hey guys!

I'm trying to upload a file, it works well with smaller files but with 60mb+, I get

need help in dynamic select menu in php
hi i have created a dynamic select menu using php. i have a problem in that which is when the user s

that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.html

I don't think my c

need Array help
This is what I have to do.
$teamname[1] = "Red Sox"
$teamname[2] = "Gian

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f