Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limiting queried results to 20 per page

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Does anybody know how to do this?<br><br>thanx
 
add <br><br>LIMIT 20 <br><br>to the end of your query
 
if you want to page through them use LIMIT 'start', 'limit' where sart is the offset and limit is the number of results (i.e. 20)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top