applying limit on records using php and mysql

To limit records using php and mysql is very easy. Just you need to write this select query instead of simple select query.

$limit_records=2;
$select_query="select * from student limit $limit_record";

or you can also write this query like below

$select_query="select * from student limit 2";

Its up to you how much limit you apply over sql query. Normally limit apply on query during development of Pagination Module.

So this is the way to apply limit on mysql query to limit the records.