Selecting a certain number of results from a specified row

Expand Post »

As the title says, I'd like to select a certain number of rows from a table starting from a specified row.

So for example, I have a table with 250 rows and the rows are numbered incrementally using a column called 'ref'. I now want to select rows 51-100. How would I go about doing that?

Similar Threads

Clean Previous Next Script for MySQL results in PHP
Getting next and previous row in a MySQL set! in PHP
Ur help please!! in PHP
php search form with paged results proplem in PHP
selecting html table row for deletion in JavaScript / DHTML / AJAX

Venom Rush

Reputation Points: 18

Solved Threads: 2

Posting Whiz

Offline

325 posts
since Oct 2007

Permalink

Oct 21st, 2009

Re: Selecting a certain number of results from a specified row

I solved my problem by using the following:

mysql Syntax (Toggle Plain Text)
WHERE ref BETWEEN 1 AND 50
WHERE ref BETWEEN 1 AND 50

Venom Rush

Reputation Points: 18

Solved Threads: 2

Posting Whiz

Offline

325 posts
since Oct 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: challenging query - Insert On duplicate field? not on duplicate key

Next Thread in MySQL Forum Timeline: Best way to save image submitted via a form

DaniWeb Message

Cancel Changes

User Name
Password