Re: Accessing data from next row? (mysql)

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.