Обсуждение: Fw: pop-up multiselection array and where condition
Hi, I've to perform a where condition which includes the output from a multiselectio pop-up: ie user can choose one or more item from a pop-up munu, let's say (item1,item3,item10), then I want to send this set of values as an array or table via php to a query that should have as where condition some like that: select * from table1 where field1 is in (array{item1,item3,item10}) is there a stright way to do that ? thanks in advance and best regards Giu -- -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: 250 biglietti da visita Gratis + 42 modelli e Etichette per Indirizzo Gratis + Porta biglietti Gratis -Offerta limitata! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6785&d=20070829
>>> On Wed, Aug 29, 2007 at 1:53 AM, in message <6e07a86b040326879dfe5a7bfb1337c5@164.129.1.43>, <giuseppe.derossi@email.it> wrote: > I've to perform a where condition which includes the output from a > multiselectio pop-up: ie user can choose one or more item from a pop-up > munu, let's say (item1,item3,item10), then I want to send this set of > values > as an array or table via php to a query that should have as where condition > some like that: > > select * from table1 where field1 is in (array{item1,item3,item10}) Have you tried?: select * from table1 where field1 in (item1,item3,item10) -Kevin