pagination using MySql
can anybody get any query for pagination using MySql.. any helps are welcome
Software/Hardware used:
Software/Hardware used:
ASKED:
July 13, 2010 11:50 AM
UPDATED:
July 13, 2010 6:18 PM
Answer Wiki:
Typically, you would do that using the LIMIT clause, which can take 2 arguments the first being the offset of the first record to return, and the second being the number of records to return.
Some examples:
This would return the first 15 records from yourTable:
<pre>SELECT * FROM yourTable LIMIT 0,15;</pre>
And this would return records 16-30:
<pre>SELECT * FROM yourTable LIMIT 15,15;</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
