Number of rows to be displayed!!!

[Anon]

I am using PHP, MYSQL and Apache Webserver for developing Online
Database.

I have a problem of limiting results,

Suppose that the result of " select * from table; " will be 80 records
and I want to display 10 records at per page.

Can you give me an idea how to limit the select results,

Solomon

[[deleted]]

you could try searching the forum/manual before asking this.

SELECT * FROM table WHERE foo LIMIT offset, length;