Fw: pop-up multiselection array and where condition

Поиск
Список
Период
Сортировка
Искать

Fw: pop-up multiselection array and where condition

От:
giuseppe.derossi@email.it
Дата:
 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


Re: Fw: pop-up multiselection array and where condition

От:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Дата:
>>> On Wed, Aug 29, 2007 at  1:53 AM, in message
<6e07a86b040326879dfe5a7bfb1337c5@164.129.1.43>, 
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
 


FAQ