Putting Mysql results into a multidimensional php array

Question

I have a mysql table which I want to have it as a PHP array. Suppose we have a field call id and another field called name. As there may be not one result in the table I want something like $result[0]['id'] to point the first result's id. I thought of this:

$result = mysql_query("SELECT * FROM db_name
                                 WHERE dependence = 0");
            $rows = array();
            while($row = mysql_fetch_assoc($result)){
                $rows = $row;
            }
            echo $rows[0]['name'];

But it doesn't work!!! Would you please help me?

subas_poudel · Accepted Answer · 2014-09-02 11:43:52Z

2

$result = mysql_query("SELECT * FROM db_name
                             WHERE dependence = 0");
$rows = array();
while($row = mysql_fetch_assoc($result)){
   $rows[] = $row;
}

answered Sep 2, 2014 at 11:43

subas_poudel

4562 silver badges17 bronze badges

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

Comments

Ram Sharma · Accepted Answer · 2014-09-02 11:42:52Z

1

try this

     $i=0;
     while($row = mysql_fetch_assoc($result)){
         $rows[$i] = $row['id'];
         $rows[$i] = $row['name']; 
      $i++;  
     }

answered Sep 2, 2014 at 11:42

Ram Sharma

8,8157 gold badges48 silver badges59 bronze badges

1 Comment

Naruto Over a year ago

Solution is fine, however, you don't even need $i and since $row is a named array, you can just add the row to the new array..

Punitha Subramani · Accepted Answer · 2014-09-02 11:59:25Z

0

You forgot to give column name

 while($row = mysql_fetch_array($result)){
    echo $row['colname'];//fill inside which column you need $row['colname']
 }

edited Sep 2, 2014 at 11:59

answered Sep 2, 2014 at 11:44

Punitha Subramani

1,4621 gold badge8 silver badges6 bronze badges

Collectives™ on Stack Overflow

Putting Mysql results into a multidimensional php array

3 Answers 3

Comments

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Related