limiting record reads

[brianm]

I am using PHP/Mysql to maintain a database, from which I build web pages, based on a user query. I wish to limit the responses to (say) 50 per page, with the option of continuing with the next 50 etc. Any suggestions?

[mrmufin]

"SELECT stuff FROM table WHERE condition='some condition' LIMIT 50";

[james2010]

$starting_record = 0;
$limiter = 50;

"SELECT stuff FROM table WHERE condition='some condition' LIMIT $starting_record, $limiter";

Then change $starting_record for each new page

[brianm]

Many thanks