Posted by Sebastien Pahud on 09/29/18 11:14

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 ? I
need to get it specifically, and not all the row.
$table['de'] will return the 1st one. (Gutentag in my example) I need
the 3rd one... or the 2nd... and so on.

$table[2][2]; or anything like this doesn't seem to work.

mysql_fetch_assoc, mysql_fetch_row, mysql_fetch_array........ Well, what
and how should i use this....

Hope you got my broken english

Thanks

Seb

[Back to original message]