query help

[n_amalyna]

hyee.. if i'm combining 2 table.. how can i set where code='$id'? this is my code

<?
$aProduct = 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($aProduct) )
{
echo "---";
}
else
{
foreach ($aProduct as $rowProduct)
{
echo $rowProduct[0];
}
}
?>
</select>

[Habtom]

at the end

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 WHERE code = '$id'

but check if it is p.code or o.code