Hey,
I'm trying to write a SELECT query based on an array to match up $ses_prod_id[] with product_id. I've written an UPDATE before using IN($imploded_array), but this doesn't work here, I get nothing back. Ideas welcome!
$ses_prod_id_imp = implode($ses_prod_id,"," );
$price_total_sql = " SELECT * FROM myselection_products WHERE product_id = (\"$ses_prod_id_imp\")";
Cheers,
Ben
I'm trying to write a SELECT query based on an array to match up $ses_prod_id[] with product_id. I've written an UPDATE before using IN($imploded_array), but this doesn't work here, I get nothing back. Ideas welcome!
$ses_prod_id_imp = implode($ses_prod_id,"," );
$price_total_sql = " SELECT * FROM myselection_products WHERE product_id = (\"$ses_prod_id_imp\")";
Cheers,
Ben