WHERE-Teil einer SQL-Abfrage in php führt zu 'Parse Error'

[mkinzler]

Der Fehler liegt höchstwahrscheinlich woanders nämlich bei der Variable PRODUCTS ohne $

Zitat:

Code:

/ list categories and products
foreach ($prod_cats as $prod_cat)
{
  $arr_products = get_sql_array("SELECT id, prod_article_no, prod_title,
    prod_price FROM " . PRODUCTS . " WHERE prod_cat_id = $prod_cat['id']");

ändere mal in

Code:

/ list categories and products
foreach ($prod_cats as $prod_cat)
{
  $arr_products = get_sql_array("SELECT id, prod_article_no, prod_title,
    prod_price FROM " . $PRODUCTS . " WHERE prod_cat_id = $prod_cat['id']");