how to know you are at the end of a quer

[Anon]

I am trying to figure out if there is a way for php to let you know that you have reached the end of a set of results for a given query, sort of like EOF...

So let's say you have a query with a limit cluase of range x to range y. If in your query your range is say 20 to 40 but the query only returns 15 results, is there a way to report that the there are no more results to return?

Any help is appreciated.

[Anon]

Well, mysql_fetch_array() (and query fetchers), will return false when there are no more of a dataset to retrieve. That is how you will know when you are at the end of your query. 🙂

Hope this helps.

-Josh

[Anon]

think of your results as an array which can be tested in while loop. when there are no more rows to work with the loop will exit. if yr using mysql, for instance:

<?php
mysql_connect($host,$user,$password);
$result = mysql_db_query("database","select * from table");
while($row = mysql_fetch_array($result)) {
echo $row["user_id"];
echo $row["fullname"];
}
mysql_free_result($result);
?>

(this example is from the manual.) there are also DB functions which will tell you the number of results returned (eg. mysql_num_rows) so you could test if it's less than 20 or whatever.