burntheblobs Posted November 10, 2008 Share Posted November 10, 2008 I have a database search on one of my pages and I am trying to break up every ten results with a new page. The problem is trying to figure out a way to get results from a certain row number on (i.e. page two would start at row number 11, not the first row). Keep in mind this isn't as simple as selection row number 11 from the database because it has two be row 11 from the array of search results. Any thoughts? Quote Link to comment https://forums.phpfreaks.com/topic/132098-solved-starting-a-mysql-query-at-a-certain-row-number/ Share on other sites More sharing options...
JasonLewis Posted November 10, 2008 Share Posted November 10, 2008 The LIMIT can be set. Google "PHP & MySQL Pagination" or something along those lines, as long as it has Pagination in it. Quote Link to comment https://forums.phpfreaks.com/topic/132098-solved-starting-a-mysql-query-at-a-certain-row-number/#findComment-686489 Share on other sites More sharing options...
haku Posted November 10, 2008 Share Posted November 10, 2008 SELECT field FROM table LIMIT starting_row, number_of_rows Where starting_row is the number of the first row that you want to grab, and number_of_rows is... Well, that's what it is. Quote Link to comment https://forums.phpfreaks.com/topic/132098-solved-starting-a-mysql-query-at-a-certain-row-number/#findComment-686593 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.