assoc array php mysql

Question

Want to change array.

    while ($row=mysql_fetch_assoc($arresult['result'])){
        $arr[] = $row;                              
        }

result:

     $arr =
   0 => id              => 52122
         DECLARED_FAULT => blabla
         CNT            => 55
         add_time       => 2016-06-07 13:26:02

    1 => id             => 52123
         DECLARED_FAULT => blabla2
         CNT            => 93
         add_time       => 2016-06-07 13:26:05

Need a kind of array

DECLARED_FAULT => 52122 => blabla
                  52123 => blabla2

CNT            => 52122 => 55
                  52123 => 93

ADD_TIME       => 52122 => 2016-06-07 13:26:02
                  52123 => 2016-06-07 13:26:05

$row["id"] unique in mysql;

while ($row=mysql_fetch_assoc($arresult['result'])){

        $arr["DECLARED_FAULT"] = array( $row["id"] => $row["DECLARED_FAULT"] ); 
        $arr["CNT"] =            array(  $row["id"] => $row["CNT"] );       
        $arr["ADD_TIME"] =       array( $row["id"] => $row["ADD_TIME"] );   

        }

this fetching give me only one record

array(3) { ["DECLARED_FAULT"]=> array(1) { [54051]=> string(71) "blabla" } ["CNT"]=> array(1) { [54051]=> string(2) "11" } ["ADD_TIME"]=> array(1) { [54051]=> string(19) "2016-06-07 13:26:02" } }

instead of this $arresult['result'] write $query variable.

srinivas
– srinivas

2016-06-07 11:07:59 +00:00
Commented Jun 7, 2016 at 11:07 — srinivas
– srinivas, Commented Jun 7, 2016 at 11:07

phreakv6 · Accepted Answer · 2016-06-07 11:06:58Z

1

Please try this.

while ($row=mysql_fetch_assoc($arresult['result'])){

    $arr["DECLARED_FAULT"][$row["id"]] = $row["DECLARED_FAULT"];
    $arr["CNT"][$row["id"]]  =            $row["CNT"];
    $arr["ADD_TIME"][$row["id"]] =       $row["ADD_TIME"];   

}

answered Jun 7, 2016 at 11:06

phreakv6

2,1651 gold badge11 silver badges11 bronze badges

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

1 Comment

Chilion Over a year ago

This one is also an option, according to what he wants not the correct one. He wants to have an array. On the other hand, technically your answer might be better.

Chilion · Accepted Answer · 2016-06-07 11:05:33Z

0

You must make an extra array for this, try this code;

while ($row=mysql_fetch_assoc($arresult['result'])){

    $arr["DECLARED_FAULT"][] = array( $row["id"] => $row["DECLARED_FAULT"] ); 
    $arr["CNT"][] =            array(  $row["id"] => $row["CNT"] );       
    $arr["ADD_TIME"][] =       array( $row["id"] => $row["ADD_TIME"] );   

    }

And try to dump that again. You will now have 3 arrays inside DECLARED_FAULT and the other ones

answered Jun 7, 2016 at 11:05

Chilion

4,5304 gold badges36 silver badges48 bronze badges

Collectives™ on Stack Overflow

assoc array php mysql

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related