Re: Fetch_row

At 2:17 AM +0000 4/13/01, Mike P wrote:

Can I use Mysql fetch_row to specify which row i want to get? Like---$row[5]=mysql_fetch_row($result) ? Mike P mpeloso@princeton.edu

Are you talking about a specific row in the mySQL result set? If so, use the mysql_result() function. However, this function only returns one column at a time, so you'd have to loop, something like: $i=0; unset($row); while ($Value = mysql_result($ResultId, 4, $i)) {

      $row[] = $Value;
      $i++;

} Note I used row # 4 in the mysql_result() call instead of 5, since (I'm 89% sure) row counts are 0-based. I'm also pretty sure you CANNOT use mysql_result() to position to the desired row, then use mysql_fetch_array() or a similar function to fetch the whole row. See http://www.php.net/manual/en/function.mysql-result.php for more info. You may be able to use the mysql LIMIT functionality to do what you want: $Query = 'SELECT * FROM table ORDER BY name LIMIT 4,1'; This grabs the fifth (again, row counts are 0-based) row. See http://www.mysql.com/doc/S/E/SELECT.html Incidentally, your original statement $row[5]=mysql_fetch_row($result); would simply create a 1-element array $row, with the array index 5. If this was your first fetch statement, $row[5] would still contain the first row of the result set. -steve -- +----------- 12 April 2001: Forty years of manned spaceflight -----------+ | Steve Edberg University of California, Davis | | sbedberg@ucdavis.edu Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +-------------------------- www.yurisnight.net --------------------------+