<div>
if u are looking for pagination, this would help <br />
<a href="http://www.phpwned.org/tutorials/view/13-php/3-advanced-pagination" rel="ugc">http://www.phpwned.org/tutorials/view/13-php/3-advanced-pagination</a><br />

</div>


<div>
Yeah that's what I'm looking for, but having problems with the example. I'm using mysql &gt;&nbsp;5, but I get an error using &quot;SQL_CALC_ROWS&quot;.<br />
<br />
i tried using the COUNT(*) method but don't get what &quot;page&quot; is supposed to be in his example:<br />
<br />
// get the roowcount<br />
$rowcount = mysql_result(mysql_query(&quot;<wbr />SELECT COUNT(*) FROM comments WHERE page=5&quot;), 0);<br />
<br />
// perform the query that actually fetches the data we want<br />
$q = mysql_query(&quot;SELECT id, name, comment FROM comments WHERE page=5 LIMIT 0, 10&quot;);<br />
<br />
<br />
My table is just ordered by auto integer id. What should I replace?<br />
<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Does any one have a generic bit of code that will create a list of page # results a user can move between, similar to how google/youtube list pages of search results? Something like:<br />
<br />
1) User comes to page for first time<br />
2) Previous view # not set, see how many widget records i have in database table<br />
3) I want to like 20 widgets per page, and have 60 widget records, so I list:<br />
4) &nbsp;Page: &nbsp;1 2 3<br />
5) Each of the above is a clickable link to just refresh the page with the next batch of widgets<br />
6) I want to show max 10 pages, then as the user clicks towards the end of the current page listing, they all shift over to reveal more page links.<br />
<br />
Thanks
</div>
</div>


Hi,

Does any one have a generic bit of code that will create a list of page # results a user can move between, similar to how google/youtube list pages of search results? Something like:

1) User comes to page for first time
2) Previous view # not set, see how many widget records i have in database table
3) I want to like 20 widgets per page, and have 60 widget records, so I list:
4)  Page:  1 2 3
5) Each of the above is a clickable link to just refresh the page with the next batch of widgets
6) I want to show max 10 pages, then as the user clicks towards the end of the current page listing, they all shift over to reveal more page links.

Thanks

Doing a simple page listing of search results

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

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.