...

View Full Version : help with query ?



nurvirus
07-30-2007, 10:19 AM
http://i12.photobucket.com/albums/a208/n_amalyna/table.jpg

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 "---";
}
else
{
foreach ($aPrice as $rowPrice)
{
echo "RM " .$rowPrice[1];
}
}
?>
</td>

saeed
07-30-2007, 10: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