TFlan: yeah, I've tried that alright, but no luck ...
hinch: thanks for that tip, good thinking. so I'm trying:
$query = $conn->prepare("SELECT id,make,model,price,availability,category,photo FROM products WHERE id IN :array");
But it's giving me error SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Array'' at line 1.
What would be the right syntax here boys?