If you're going to prepare/execute this many times, and you only have (up to) a few values, it might be worthwhile to use the join(",", ("?") x $n) technique, and use prepare_cached. If you might have up to many (100?) values, then forget the placeholders and prepare_cached, and use the quote() method on the values if necessary to create dynamic SQL every time.