Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3335E9F95D5 for ; Mon, 27 Aug 2007 07:10:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 46867-02 for ; Mon, 27 Aug 2007 07:10:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp-out02.email.it (smtp-out02.email.it [212.97.34.22]) by postgresql.org (Postfix) with ESMTP id 299149F95D3 for ; Mon, 27 Aug 2007 07:10:07 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out02.email.it (Postfix) with ESMTP id 9AC7B2C00F for ; Mon, 27 Aug 2007 12:10:04 +0200 (CEST) X-Virus-Scanned: amavisd-new at email.it Received: from smtp-out02.email.it ([127.0.0.1]) by localhost (smtp-out02.email.it [127.0.0.1]) (amavisd-new, port 10024) with LMTP id BIjbPTiu7Y7j for ; Mon, 27 Aug 2007 12:10:03 +0200 (CEST) Date: Mon, 27 Aug 2007 12:10:02 +0200 To: pgsql-admin@postgresql.org From: giuseppe.derossi@email.it Reply-to: giuseppe.derossi@email.it Subject: pop-up multiselection array and where condition Message-ID: <12a10085a718dbc97157094901d7c60d@164.129.1.43> X-Priority: X-Mailer: Webmail-Email.it [Mailer version 1.70] X-SenderIP: 164.129.1.43 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/326 X-Sequence-Number: 26657 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: KILL BILL! scarica la colonna sonora del film: è in REGALO! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6614&d=20070827