CODEWITHSUNDEEP
phpmysqlarraysfetch
Vladimir Lenkov
Vladimir Lenkov

Reputation: 73

assoc array php mysql

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" } }

Upvotes: 3

Views: 53

Answers (2)

phreakv6
phreakv6

Reputation: 2165

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"];   

}

Upvotes: 1

Chilion
Chilion

Reputation: 4490

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

Upvotes: 0

Related Questions