Posted by Brian V Bonini on 09/29/16 11:14

On Tue, 2005-04-26 at 17:05, Sebastien Pahud wrote:
> Hello,
>
> I cannot figure out how to read a specific "cell" in a result i got from
> a SQL request.
>
> I have a SQL request on a database:
> SELECT nameAttribute, fr, de, en
> FROM traduction
> WHERE nameTable = 'whatever'
> AND idTable = 1
> ORDER BY nameAttribute
>
> and i am suppose to get something like this :
>
> ---------------------------------------------
> | msg | bonjour | gutentag | good morning |
> ---------------------------------------------
> | time | diner | essen | lunch |
> ---------------------------------------------
> | weather | beau | schön | nice |
> ---------------------------------------------
>
> I always know how many rows i am suppose to get.
>
> Now, how can i get the word "schön" for example out from that table

SELECT * FROM traduction WHERE nameAttribute='weather' AND de='schön';

??

--

s/:-[(/]/:-)/g


Brian GnuPG -> KeyID: 0x04A4F0DC | Key Server: pgp.mit.edu
======================================================================
gpg --keyserver pgp.mit.edu --recv-keys 04A4F0DC
Key Info: http://gfx-design.com/keys
Linux Registered User #339825 at http://counter.li.org

[Back to original message]