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

records between 2 dates
Hello all,

I have a date tracked table which contains effective_start_date and effective

Help uploading .JPG
I have a problem with upload images when the ending is .JPG capitalized.. I really don't know what c

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

user validation always displaying invalid ? please help
Hello,

I have 2 accounts and there is a field in mysql called validated it can be either &quo

Mysterious Timeouts
I've deployed a few simple AJAX-enabled web page to a local server that is accessed through the Inte

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai

PHP Code To Change Font Color in Table Cell
I would appreciate help with the following snippet of my php code. I am just trying to change the f

Best way to read this text file.
Hi.I am planning to make a small application in C# to convert the players from Football manager 2010

Issue Parsing XML into table
Hello all,

Im a bit new to php and new to phpfreaks. But thanks in advance for the help!
<