Putting MySQL query into an array...

[listenmirndt]

So I am trying to adapt a jquery shopping cart plug in to pull my own product database...

$product_array = array("100" =>array('product_id'=>'100', 'product_name'=>'Apple IPhone 3G', 'product_price'=>'1450.75', 'product_img'=>'images/product0.jpg'),
                       "101" =>array('product_id'=>'101', 'product_name'=>'Ice Pot', 'product_price'=>'10.25', 'product_img'=>'images/product1.jpg'),
                       "102" =>array('product_id'=>'102', 'product_name'=>'Style Stand', 'product_price'=>'6.15', 'product_img'=>'images/product2.jpg'),
                       "103" =>array('product_id'=>'103', 'product_name'=>'Coffe Maker', 'product_price'=>'120.35', 'product_img'=>'images/product3.jpg'),
                       "104" =>array('product_id'=>'104', 'product_name'=>'Wood Cutter', 'product_price'=>'80.99', 'product_img'=>'images/product4.jpg'),
                       "105" =>array('product_id'=>'105', 'product_name'=>'Office Clip Pad', 'product_price'=>'20.15', 'product_img'=>'images/product5.jpg'),
                       "106" =>array('product_id'=>'106', 'product_name'=>'Laptop', 'product_price'=>'2220.00', 'product_img'=>'images/product6.jpg'),
                       "107" =>array('product_id'=>'107', 'product_name'=>'Apple Mac', 'product_price'=>'3450.75', 'product_img'=>'images/product7.jpg'),
                       "108" =>array('product_id'=>'108', 'product_name'=>'Headphone', 'product_price'=>'100.48', 'product_img'=>'images/product8.jpg'),
                       "109" =>array('product_id'=>'109', 'product_name'=>'Home Theater System', 'product_price'=>'14520.75', 'product_img'=>'images/product9.jpg'),
                       "110" =>array('product_id'=>'110', 'product_name'=>'SanDisk USB Drive', 'product_price'=>'240.75', 'product_img'=>'images/product10.jpg'),
                       "111" =>array('product_id'=>'111', 'product_name'=>'Blackberry Smart', 'product_price'=>'2450.75', 'product_img'=>'images/product11.jpg'));

This is the example array...

basically I need to make a MySQL query that produces an array in that format, but with my own products from my database...

so that I just just replace $product_array with a MySQL loop of db product entries...

not too sure how to code this...

[jeepin81]

create an array.

$products  = array();
while($row = mysql_fetch_assoc($res)){
	$id = $row['product_id'];
	$products[$id]['product_name'] = $row['product_name'];
	$products[$id]['product_price'] = $row['product_price'];
	$products[$id]['product_img'] = $row['product_img'];
}

[NogDog]

Assuming the DB column names match the desired array key names, if you make sure the the id is the first column in the select clause, you could do the following (not necessarily better, just a bit different):

$sql = "SELECT product_id, product_name, product_price, product_image FROM . . .";
$result = mysql_query($sql);
$product_array = array();
if($result == false) {
   // error-handling here
} else {
   while($row = mysql_fetch_assoc($result)) {
      $id = array_shift($row);
      $product_array[$id] = $row;
   }
}