table to array help. so simple.

[chaost]

Hi,

 

This is bugging me and should be soooooo simple. Help please!

 

I have a myslq table with 3 fields.

<id><item><result>.

1  fish    15

4  cats    10

6  frogs  50

 

I need to build an array like this

 

array(

        [1] => array([item] => fish,  [result] => 15),

        [4] => array([item] => cats, [result] => 10),

        [6] => array([item] => frogs,[result] => 50)

)

 

thank you very much in advance for the help!!!

 

 

[Bauer418]

<?php
$query = "SELECT * FROM table_name";
$result = mysql_query($query) or die(mysql_error());
$table = array();
while ($row = mysql_fetch_assoc($result))
{
     $table[$row['id']] = $row;
}
print_r($table);
?>

[jeremyphphaven]

totally confused.  didn't you just build the array? lol

 

<?php
$array = array();
// MYSQL DATABASE LOOP FUNCTIONALITY (assuming you're using MYSQL)
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    array_push($array,$row['id'] => array([item] => $row['item'],  [result] => $row['result']));
}
?>

 

Just to note, I didn't test this and just wrote it out here, so may need tweaking but should work just fine.

 

[chaost]

lol.

 

yes, thanks guys, it was simple. I have just started using an sql class to speed things up and the result array was confusing me. Bringing it back to basic - always helps...

 

Thank you!