pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: SELECT column name
3+ messages / 3 participants
[nested] [flat]

* SELECT column name
@ 2001-07-10 14:47 Laurent Patureau <lpatureau@idfr.net>
  2001-07-10 08:52 ` Re: SELECT column name Martín Marqués <martin@bugs.unl.edu.ar>
  2001-07-11 13:44 ` Re: SELECT column name Adam Lang <aalang@rutgersinsurance.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Laurent Patureau @ 2001-07-10 14:47 UTC (permalink / raw)
  To: pgsql-php

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SELECT column name
  2001-07-10 14:47 SELECT column name Laurent Patureau <lpatureau@idfr.net>
@ 2001-07-10 08:52 ` Martín Marqués <martin@bugs.unl.edu.ar>
  1 sibling, 0 replies; 3+ messages in thread

From: Martín Marqués @ 2001-07-10 08:52 UTC (permalink / raw)
  To: Laurent Patureau <lpatureau@idfr.net>; +Cc: pgsql-php

On Mar 10 Jul 2001 11:47, you wrote:
> 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'

Could this be:

SELECT columns_name WHERE client=CURRENT_USER AND column.values='oui'

Saludos... :-)

-- 
Cualquiera administra un NT.
Ese es el problema, que cualquiera administre.
-----------------------------------------------------------------
Martin Marques                  |        mmarques@unl.edu.ar
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SELECT column name
  2001-07-10 14:47 SELECT column name Laurent Patureau <lpatureau@idfr.net>
@ 2001-07-11 13:44 ` Adam Lang <aalang@rutgersinsurance.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Adam Lang @ 2001-07-11 13:44 UTC (permalink / raw)
  To: pgsql-php

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" <lpatureau@idfr.net>
To: <pgsql-php@postgresql.org>
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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-07-11 13:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-10 14:47 SELECT column name Laurent Patureau <lpatureau@idfr.net>
2001-07-10 08:52 ` Martín Marqués <martin@bugs.unl.edu.ar>
2001-07-11 13:44 ` Adam Lang <aalang@rutgersinsurance.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox