[RESOLVED] Sorting Mysql results into multi-dimensional arrays

[Trilogen]

while ($get_info = mysql_fetch_row/COLOR){
$products[]=
foreach ($get_info as $field) <- I get a parse error here
$products[][]=$field;
}

Basically I want the results indexed neatly in the $products array.
I want it to be something like this.

0. ProductName, Price
1. ProductName, Price
2. ProductName, Price
3. ProductName, Price
   etc...

inside the products array where the numbers are the index and ProductName & Price are inside the index.

Hope that made sense :o

I've never done something like this, some examples or suggestion would be greatly appreciated!

[lucasrd]

Instead of a multi-dimensional array, you could just do a parallel array...for instance:

$products[0] = "Product Name 0";
$prices[0] = "Price 0";

[Trilogen]

$products[0] = "Product Name 0";
$prices[0] = "Price 0";

I guess I could do that, but how would I get the each field in the right array?

this is what I mean:

foreach ($get_info as $field) <- I get a parse error here
$products[0] =  $field;
$prices[0] =  $field;
} 

[lucasrd]

I am guessing you are selecting the records from a products table...

$products = array();
$prices = array();

$sql = "select * from products";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
   $products[count($products)] = $row['product_name'];
   $prices[count($prices)] = $row['price'];
}
reset($products);
reset($prices);

[Trilogen]

I'll take that into consideration Lucasrd, thanks.

Just curios though will this work?

for($i=0;$i==$num_rows;$i++){
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
   $product[$i][0] = $row[0];
   $product[$i][1] = $row[1];
}
}

I guess I'm abit paranoid but I just want to make sure the fields matchup thats why I prefer having them in a multidimensional array.

[Trilogen]

YESSSS! This works:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
$products=array(array($row[0], $row[1]));
}

Thank you to all that tried to help. I will add your name and links to your site in my credits page 😃