Re: [GENERAL] Prepared statements with a variable number of parameters

2009-10-10 Thread Raymond O'Donnell
On 10/10/2009 18:52, Pavel Stehule wrote: > 2009/10/10 Raymond O'Donnell : >> My question is, what do people normally do when there's a variable >> number of parameters? - for example: >> >> select . where item_id in ( ... ); >> > > You can use arrays here. > > select ... where item_id = A

Re: [GENERAL] Prepared statements with a variable number of parameters

2009-10-10 Thread Pavel Stehule
Hello 2009/10/10 Raymond O'Donnell : > I'm using PDO in PHP for database access (actually Zend Framework), and > following best practice by using parameters in prepared statements. > > My question is, what do people normally do when there's a variable > number of parameters? - for example: > >  se

[GENERAL] Prepared statements with a variable number of parameters

2009-10-10 Thread Raymond O'Donnell
I'm using PDO in PHP for database access (actually Zend Framework), and following best practice by using parameters in prepared statements. My question is, what do people normally do when there's a variable number of parameters? - for example: select . where item_id in ( ... ); In this cas