Received: from bush.rutgersinsurance.com (rutgersinsurance.com [38.138.71.194]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6BDg2a67896 for ; Wed, 11 Jul 2001 09:42:02 -0400 (EDT) (envelope-from aalang@rutgersinsurance.com) Received: from nj012 ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id KAA00883 for ; Wed, 11 Jul 2001 10:03:42 -0400 Message-ID: <005c01c10a0f$8e906720$330a0a0a@rutgersinsurance.com> From: "Adam Lang" To: References: <5.1.0.14.0.20010710164328.00a258e0@172.16.48.1> Subject: Re: SELECT column name Date: Wed, 11 Jul 2001 09:44:07 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/10 X-Sequence-Number: 467 You are missing the FROM clause. Sort of need to tell it which table to run the query on. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Laurent Patureau" To: Sent: Tuesday, July 10, 2001 10:47 AM Subject: [PHP] SELECT column name > Hi, > > I 'd like to select column name on table for a client Where value for this > client for columns is yes : > > SELECT columns_name WHERE client='$client' AND column.values='oui' > > Is anybody can help me ? > > Thanks > LP > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org