View Full Version : help with query ?

07-30-2007, 09:19 AM

hey everyone,

i hve a problem here... what i need to display is just one price... but as u can see... it displays 2 price at a time... can someone help me scan where is my mistake?

<input type="hidden" name="payment" >
$aPrice = db_query("SELECT p.product_desc,o.dt_order_product_price,o.dt_order_order_code from product_ms p inner join order_dt o
on o.dt_order_product_code=p.product_code");
if (!is_array($aPrice) )
echo "---";
foreach ($aPrice as $rowPrice)
echo "RM " .$rowPrice[1];

07-30-2007, 09:30 AM
u need to be more specific and btw... thread is supposed to be in Database and not in PHP...

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum