FREELessons: 21Length: 2.3 hours

Next lesson playing in 5 seconds

  • Overview
  • Transcript

4.2 Choosing a Number of Records

After using a 'where' clause to filter through your results, you might find you still have too many for your purpose. Maybe you only want to display a certain number of items: think of a product table or search result page, where results are paginated with, say, 20 per page. We don’t want to pull all the records from the database at once, so how do we pull just enough for one page?