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@xxxxxxxx] Sent: Tuesday, April 26, 2005 5:52 PM
To: php-general@xxxxxxxxxxxxx
Subject: Re: 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
_______________________________________
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
