<div>
You can also store the start and end rows in variables to be able to produce the paging functions you see everywhere. You pass these variables in the url with strings for next, previous paging
</div>


You can also store the start and end rows in variables to be able to produce the paging functions you see everywhere. You pass these variables in the url with strings for next, previous paging

<div>
Repost from duplicate question:<br />
<br />
Hi abhishek2002,<br />
<br />
If you are using MySQL you can write<br />
<br />
SELECT * FROM myTable LIMIT 0,10<br />
<br />
where 0 is startrow and 10 is number of records you want to return<br />
<br />
Read more: <a href="http://dev.mysql.com/doc/mysql/en/SELECT.html" rel="ugc nofollow">http://dev.mysql.com/doc/mysql/en/SELECT.html</a><br />
<br />
//jan
</div>


Repost from duplicate question:

Hi abhishek2002,

If you are using MySQL you can write

SELECT * FROM myTable LIMIT 0,10

where 0 is startrow and 10 is number of records you want to return

Read more: http://dev.mysql.com/doc/mysql/en/SELECT.html [http://dev.mysql.com/doc/mysql/en/SELECT.html]

//jan

<div>
<div class="content wysiwyg-content">
how can i limit rows while getting result from database?
</div>
</div>


how can i limit rows while getting result from database?

limiting rows

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.