Jump to content

[SOLVED] building dynamic query


xiao

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.