Вот код. Не могу понять где ошибка:
$sort='asc';
$sql = "SELECT * FROM open_product_prices, open_product_descriptions, open_products_categories, open_products WHERE open_product_prices.product_id = open_product_descriptions.product_id and open_product_prices.product_id = open_products_categories.product_id and open_product_prices.product_id = open_products.product_id and category_id=211 and list_price>0 ORDER BY price $sort";
$result = mysql_query($sql) or die(mysql_error());
$table = "
Артикул | Наименование | Реком. цена | Цена АКЦИЯ | Заказать |
---|
".$product_code." | ".$product." | ".$list_price." | ".$price." | Заказать |
";
echo $table;