I did what you suggested.
But for some reason that is too hard to explain, I need to check a certain value of the 1st row of each result set.
And as we know as one does this MySQL index array moves up by 1.
So I need to bring this pointed back to where it was, which I am doing with:
this works fine in case of LIMIT 0, 15
but fails with this error message in subsequent pages, such as:
this works fine in case of LIMIT 15, 15
Warning: mysql_data_seek() [function.mysql-data-seek]: Offset 15 is invalid for MySQL result index 8 (or the query data is unbuffered) in /var/www/html/anoox.com/find_new.php on line 293
and I see that then the results are displayed starting from row 18!
You know what the hek is going on?