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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>>> On Wed, Aug 29, 2007 at  1:53 AM, in message
<6e07a86b040326879dfe5a7bfb1337c5@xxxxxxxxxxxx>, <giuseppe.derossi@xxxxxxxx>
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
 



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux