Jump to content


Photo

100 records, only 10 seen!!


  • Please log in to reply
2 replies to this topic

#1 georglee

georglee
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 30 October 2003 - 08:53 PM

I ave created a database and ave added over 100 records to a table. I can view every record easily, the thing is i only want to view the first 10 records and i ave no idea how to do this, can you help? thanx george

#2 GeoffOs

GeoffOs
  • Members
  • PipPip
  • Member
  • 24 posts
  • LocationCheshire, England

Posted 30 October 2003 - 09:01 PM

At the end of you select line put LIMIT 0, 10
This will limit the records returned to 10 starting with the first record.
Beyond a critical point within a finite space, freedom diminishes as numbers increase....[br]The human question is not how many can possibly survive within the system, but what kind of existence is possible for those who do survive."[br]-- Frank Herbert - Dune

#3 georglee

georglee
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 30 October 2003 - 09:04 PM

thanks u r a life saver




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users