xiao Posted April 20, 2008 Share Posted April 20, 2008 I have this query: $qry = mysql_query("SELECT p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd, products_to_categories pc WHERE p.products_id = pd.products_id AND pd.language_id = '".$instT."' GROUP BY pd.products_name ORDER BY p.products_price") or die(mysql_error()); But I need some "AND PC.categories_id = $variable" in it like this: foreach($instV400 as $voedingCat){ echo "AND pc.categories_id = '".$voedingCat."' "; } So it should look somewhat like this: $qry = mysql_query("SELECT p.products_id, p.products_model, p.products_price, pd.products_name FROM products p, products_description pd, products_to_categories pc WHERE p.products_id = pd.products_id AND pd.language_id = '".$instT."' " . foreach($instV400 as $voedingCat){ echo "AND pc.categories_id = '".$voedingCat."' "; } . "GROUP BY pd.products_name ORDER BY p.products_price") or die(mysql_error()); But I have no idea how to build a query like that :-\ Link to comment https://forums.phpfreaks.com/topic/101978-solved-building-dynamic-query/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.