Multidimensional Array from SQL Table

Question

Here's the my SQL table:

order_id | product_id | deal_title | currency_code | total | date_modified

My Question is how do I make an array in PHP like in the below:

Array
(
    [product_id_num1] => Array
        (
            [order_id]
            [deal_title]
            [currency_code]
            [total]
            [date_modified]
        )
    [product_id_num2] => Array
        (
            [order_id]
            [deal_title]
            [currency_code]
            [total]
            [date_modified]
        )
    [product_id_num3] => Array
        (
            [order_id]
            [deal_title]
            [currency_code]
            [total]
            [date_modified]
        )
etc....
)

Thanks!

Do you know how to do it in brute force way?

Fallen
– Fallen

2014-07-23 17:17:53 +00:00
Commented Jul 23, 2014 at 17:17 — Fallen
– Fallen, Commented Jul 23, 2014 at 17:17
stackoverflow.com/questions/6184694/…

xQbert
– xQbert

2014-07-23 17:29:29 +00:00
Commented Jul 23, 2014 at 17:29 — xQbert
– xQbert, Commented Jul 23, 2014 at 17:29

MH2K9 · Accepted Answer · 2014-07-23 17:28:26Z

2

You can try something like below

$arr = array();
while($row = mysqli_fetch_assoc($query_result)) {
    $id = $row['product_id'];
    unset($row['product_id']);
    $arr[$id] = $row;
}

answered Jul 23, 2014 at 17:28

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Fallen Over a year ago

@EatCodePlaySleep : Are you using mysqli_* or mysql_* functions? What is the error it shows? If no error is thrown use print_r($arr) after the while block to understand the structure of $arr array

EatCodePlaySleep Over a year ago

nice! got it working now. just forgot one syntax. :)

Collectives™ on Stack Overflow

Multidimensional Array from SQL Table

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related