its basically getting products from product table and currency from currency table.
now i want to get some more products to it.
i want to select product which are in 3rd table named "catrel" where i have got catid and product id
now if the catid = 99 it shuld also select all those products.
any help.................
Code: Select all
mysql_query("
SELECT products.productID as productID,productName,image1,discounted,discountPercentage,price,displaySymbol FROM products,productprice,currency where productprice.currencyid=currency.currencyid and products.productID=productprice.productID and products.categoryID=99 and products.status=1 and productprice.currencyID=1 order by products.productID desc") or die(mysql_error());