[SOLVED] Complicated Array Help

[Fruct0se]

I am pulling a table from my database and I would like to store all of the information into a single array. The table would look something like this:

table name: taxonomy

IDCategoryidHidW

1Standard100300

2Standard200320

3Standard300390

 

4Other1030

5Other23020

6Other33010

 

I would like to store all of this information into a single array something like:

$result = $db->query("Select * from taxonomy");
		while ($i = $db->fetch_row($result)){
			extract($i);
//!*****Want to store all the data into a single array here*****
		}

[kratsg]

<?php
$holder = array();
$looper = 0;
$result = $db->query("Select * from taxonomy");
         while ($i = $db->fetch_row($result)){
                  foreach($i as $key=>$value){
                           $holder[$looper][$key] = $value;
                  }
                  $looper++;
         }
?>

 

This should work pretty nicely.

[Fruct0se]

Thanks, can you show me an easy way to show all the data in the array?

[kratsg]

print_r(array);