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? 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. 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. 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
Archived
This topic is now archived and is closed to further replies.