Re: how to read a specific "cell"

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