|
|
Posted by Sebastien Pahud on 09/29/68 11:14
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
_______________________________________
[Back to original message]
|