Thread: SELECT column name

SELECT column name

From

Laurent Patureau

Date:

10 July 2001, 13:44:38

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

Re: SELECT column name

From

Martín Marqués

Date:

10 July 2001, 14:13:38

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
-----------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: SELECT column name

From

"Adam Lang"

Date:

11 July 2001, 12:42:07

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

Re: SELECT column name

From

Martín Marqués

Date:

15 November 2001, 18:44:47

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
-----------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster