I know that, but what if I need to access data from the next row? If I
have 3 rows, is there a way to access something from row 3 while the
loop is in row 2, but still have the loop go to row 3 when it's done
with row 2?
John W. Holmes wrote:
>>Using mysql, how do I access the data of the next row using code
>>something like this:
>>$result = mysql_query("select column from table where
>>whatever='whatever'");
>>while($array = mysql_fetch_array($result)){
>>//Whatever
>>}
>>
>>
>
>Each iteration of the while loop will fetch a row for you and it's
>contents will be in the $array[] array. Try "echo $array['column'];"
>inside of your while to see what I'm talking about.
>
>---John Holmes...
>
>
>
>
>
--
The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
