georglee Posted October 30, 2003 Share Posted October 30, 2003 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 Quote Link to comment Share on other sites More sharing options...
GeoffOs Posted October 30, 2003 Share Posted October 30, 2003 At the end of you select line put LIMIT 0, 10 This will limit the records returned to 10 starting with the first record. Quote Link to comment Share on other sites More sharing options...
georglee Posted October 30, 2003 Author Share Posted October 30, 2003 thanks u r a life saver Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.