limiting rows returned from MySQL query

[Melville]

I am trying to limit the number of rows transmitted from the MySQL server to the web server. If I run a query like $result = mysql_query($query), and I get $rows_returned = mysql_num_rows($result) of 500, I would like to be able to show on this page only rows 50 - 75. (And then I will show results page numbers to give the user access to the rest.)

Is there a way that I can tell PHP to request only rows 50 - 75 from the MySQL server after I have run the initial query and found out how many rows were returned?

Thank you very much for your assistance!

Best,
Mel

[HalfaBee]

PHP can't do it , but sql can

$query = 'SELECT * from table LIMIT 10'

will return the first 10 rows.

Have a look at the manual under LIMIT
www.mysql.com/limit

[Melville]

Thank you, HalfaBee!

[brucec]

I use LIMIT in my SQL like HalfaBee mentioned, but I sometimes use a while loop with a counter and a break command when the counter is reached.

Sometimes it is more efficient than a MySQL LIMIT and sometimes it is not.

I think I use them equally.