Received: from newman.hartehanks.com (newman.hartehanks.com [204.89.158.3]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0GExd094799 for ; Tue, 16 Jan 2001 09:59:39 -0500 (EST) (envelope-from Timothy_Maguire@hartehanks.com) Received: from linmail.hartehanks.com (unverified) by newman.hartehanks.com (Content Technologies SMTPRS 4.1.5) with SMTP id for ; Tue, 16 Jan 2001 09:52:57 -0500 Received: by linmail.hartehanks.com(Lotus SMTP MTA v4.6.6 (890.1 7-16-1999)) id 852569D6.00522A5E ; Tue, 16 Jan 2001 09:57:27 -0500 X-Lotus-FromDomain: HARTE-HANKS From: Timothy_Maguire@hartehanks.com To: pgsql-php@postgresql.org Message-ID: <852569D6.00522920.00@linmail.hartehanks.com> Date: Tue, 16 Jan 2001 09:57:20 -0500 Subject: Optional fields Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Disposition: inline X-Archive-Number: 200101/55 X-Sequence-Number: 120 I have form that is used for searching a table of phone numbers. I want the user to be able to search by first name, last name, manager, extension, building, title, and department, These are all fields in the employee table. But i don't want to have any requred fields. I was wonder what would be the best way to query the table by ony filling in a few of the fields in the form. I want to use "and" in my sql statement. Does anyone have any suggestions on where I can start? Thanks, Tim.