Displaying eg 1 to 10 of a total 36 res.

[Anon]

I am displaying the total number of results from a particular search of mysql database, but I would like to say for example:
displaying "1 to 10" of 36 results, instead of Your search found 36 results.

How do I get the "1 to 10" or whatever number of results are given?

I am using
$numrows = mysql_num_rows($numresults);
where $numresults is my sql query, to display the total results.

[Anon]

Research the 'limit' keywords in mySQL

[Anon]

rt(f)m...

check for limit...query: select * from blabla (group by blabla order by blabla desc) limit int start, int how much....

[saltwater]

Yup,
SELECT <fields> FROM <table> WHERE <condition> LIMIT <start>,<length>

but if you want to know the total search results you should first do a query without LIMIT