[Resolved] mysql_data_seek, offset=0 does noit exist?

[leatherback]

Hi All, when I run the code below, and $start == 0, I get the error:

Warning: Offset 0 is invalid for MySQL result index 4 in c:\phpdev\www\public\managefotos\index.php on line 68
Cannot find result 0:

For other values it works fine, until $start == the maximum number of rows (Which is according to the manual). So basically I can only retrieve all-1 selected records this way. What am I doing wrong here?

// Create the query
$basequery = "select * from fotoinfo ".$wherestatement." order by F_Year desc, F_Id asc";

// Run the basequery  & Get the total number of selected rows
$allresults = mysql_query($basequery) or die('Could not get requested information');
    $ReturnedResults = mysql_num_rows($allresults);

mysql_data_seek($allresults, $start) or die("Cannot find result $start: " . mysql_error());

[Roger_Ramjet]

Well according to the manual base zero is correct, so $start == 0 would be fine. What it does say is

row_number starts at 0. The row_number should be a value in the range from 0 to mysql_num_rows() - 1. However if the result set is empty (mysql_num_rows() == 0), a seek to 0 will fail with a E_WARNING and mysql_data_seek() will return FALSE.

I don't see anything that is checking $start against num rows, is that just ommitted from your post?

[leatherback]

Hm.. Don't know.. I changed my config this morning, now it works well?