Getting the last row

[piersk]

How can I go about getting the last row from a query? I need to get some details from the last one and then start scrolling through them in order. (I can scroll through them, but am not sure how to get the final row first and then get the pointer to the beginning again)

[jsim]

Try this:

<?php

$link = mysql_connect( "localhost", "user", "pswd" );
mysql_select_db( "database", $link );

$result = mysql_query( "select * from table", $link );
$num_rows = mysql_num_rows( $result );

if( $num_rows > 0 ) {

  mysql_data_seek( $result, $num_rows-1 );
  $last_row = mysql_fetch_row( $result );
  print_r( $last_row );

  mysql_data_seek( $result, 0 );
}

$first_row = mysql_fetch_row( $result );
print_r( $first_row );
$second_row = mysql_fetch_row( $result );
print_r( $second_row );

// ...

?>

[piersk]

Ahh. It all becomes clear now. I had looked at the [man]mysql_data_seek()[/man] function, but wasn't entirely sure how to use it. Ta muchly mi amigo(a)