[SOLVED] Re: [PHP] how to read a specific "cell"

Thanks David, Exactly what i was looking for ! Seb David Tucker wrote:

I would do it like this : if (mysql_data_seek($result, $rownum)) $a_row = mysql_fetch_row($result); echo $a_row[$column_int]; --Codefox -----Original Message----- From: Sebastien Pahud [mailto:livestage@sp-81.ch] Sent: Tuesday, April 26, 2005 5:52 PM To: php-general@lists.php.net Subject: Re: [PHP] how to read a specific "cell" Brian V Bonini wrote:

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'; ??

Thanks Brian, but you didn't get the problem... i want to get the content with the "position" in the array, because i never know what is inside my array. ("schön" and all those inputs change) But i know the position of what i need. (because of the ORDER BY and the fact that i always get only 3 rows)

-- ________________________________________ Sébastien Pahud Salève 6 1004 Lausanne Switzerland Prof +41 (0) 21 646 63 65 Fax +41 (0) 21 646 63 65 Privé +41 (0) 21 646 63 81 Mobile +41 (0) 78 665 76 93 _______________________________________