All the code is there you need.

Just go from page to page, and use the small bits of code. Once combined it is the working example in the end.

Plus you'll be able to read along to learn how it works.

want the zip file

thanks

please!

NO zip file needed. Code is provided. You want an example of pagination? It on every tutorial, tutorial cateogry listing as well as code sections of this site. --link to full code--

  bs0d said...

< i> NO zip file needed. Code is provided. You want an example of pagination? It on every tutorial, tutorial cateogry listing as well as code sections of this site. --link to full code--

the full code also doesnt work and gives me this:

50)) { $limit = 10; //default } //set default if: $page is empty, non numerical, less than zero, greater than total available if((!$page) || (is_numeric($pa ge) == false) || ($page < 0) || ($page > $total_items)) { $page = 1; //default } //calcuate total pages $total_pages = ceil($total_ite ms / $limit); $set_limit = $page * $limit - ($limit); //query: **EDIT TO YOUR TABLE NAME, ECT. $q = mysql_query(&q uot;SELECT * FROM `table` WHERE `cat` = '".addsl ashes($_GET['c at'])." ' LIMIT $set_limit, $limit"; if(!$q) die(mysql_error ()); $err = mysql_num_rows( $q); if($err == 0) die("No matches met your criteria." ; //Results per page: **EDIT LINK PATH** echo(" 10 | 25 | 50"; //show data matching query: while($code = mysql_fetch_obj ect($q)) { echo("ite m: ".$code-& gt;title." ;
"; } $cat = urlencode($cat) ; //makes browser friendly //prev. page: **EDIT LINK PATH** $prev_page = $page - 1; if($prev_page >= 1) { echo("< ;< Prev."; } //Display middle pages: **EDIT LINK PATH** for($a = 1; $a <= $total_pages; $a++) { if($a == $page) { echo(" $a | "; //no link } else { echo(" $a | "; } } //next page: **EDIT THIS LINK PATH** $next_page = $page + 1; if($next_page <= $total_pages) { echo("Nex t > >"; } //all done ?>

Does your host allow php? and does it allow short tags?

If you have php in your host, problem could be this:

Try changing "<?&q uot; to "<?php " (without quotes)

*No database selected*

where should i make the database? I cant find to put my localhost etc...

you should have a MySQL option in your admin panel that you can use for making databases. if you need to add a table to your database you probably have PHPMyAdmin or your host might have an alternative to it. If you're using a free site host or something they might either not have MySQL or they have a small number of databases, like 3 or something, that you're allowed to use.

i have MYSQL but where should it work and why doesnt it work??????????? ??????????????? ?

do you have like an admin panel that shows all the things you can do, ie. creating files/directori es, creating databases, etc.?

  Persis said...

Cpanel?

Anyway find a option where you can add databases. Add a database and user and give all privileges to that user. Then go to phpmyadmin that should be included in the admin panel. Select your database then select SQL to insert info into your database and paste the SQL from the tutorial.

this code is uselles and doesnt work, noob scritp:

<?
//REMEMBER TO CONNECT TO DATABASE!

//**EDIT TO YOUR TABLE NAME, ECT.

$t = mysql_query(&q uot;SELECT * FROM `table` WHERE `cat` = '".addsl ashes($_GET['c at'])." '";
if(!$t) die(mysql_error ());

$a = mysql_fetch_obj ect($t);
$total_items = mysql_num_rows( $t);
$limit = $_GET['limit' ];
$type = $_GET['type'] ;
$page = $_GET['page'] ;

//set default if: $limit is empty, non numerical, less than 10, greater than 50
if((!$limit) || (is_numeric($li mit) == false) || ($limit < 10) || ($limit > 50)) {
$limit = 10; //default
}
//set default if: $page is empty, non numerical, less than zero, greater than total available
if((!$page) || (is_numeric($pa ge) == false) || ($page < 0) || ($page > $total_items)) {
$page = 1; //default
}

//calcuate total pages
$total_pages = ceil($total_ite ms / $limit);
$set_limit = $page * $limit - ($limit);

//query: **EDIT TO YOUR TABLE NAME, ECT.

$q = mysql_query(&q uot;SELECT * FROM `table` WHERE `cat` = '".addsl ashes($_GET['c at'])." ' LIMIT $set_limit, $limit";
if(!$q) die(mysql_error ());
$err = mysql_num_rows( $q);
if($err == 0) die("No matches met your criteria." ;

//Results per page: **EDIT LINK PATH**
echo("
<a href=www.yoursi te.com/stuff/sc ript.php?cat=$c at&amp;limi t=10&amp;pa ge=1>10</ a> |
<a href=www.yoursi te.com/stuff/sc ript.php?cat=$c at&amp;limi t=25&amp;pa ge=1>25</ a> |
<a href=www.yoursi te.com/stuff/sc ript.php?cat=$c at&amp;limi t=50&amp;pa ge=1>50</ a>";

//show data matching query:
while($code = mysql_fetch_obj ect($q)) {
echo("ite m: ".$code-& gt;title." ;<BR>&qu ot;
}

$cat = urlencode($cat) ; //makes browser friendly

//prev. page: **EDIT LINK PATH**

$prev_page = $page - 1;

if($prev_page >= 1) {
echo("< ;b>&lt;& amp;lt;</b&g t; <a href=http://www .yoursite.com/s tuff/script.php ?cat=$cat&a mp;limit=$limit &amp;page=$ prev_page>&l t;b>Prev.< ;/b></a&g t;";
}

//Display middle pages: **EDIT LINK PATH**

for($a = 1; $a <= $total_pages; $a++)
{
if($a == $page) {
echo("< ;b> $a</b> | "; //no link
} else {
echo(" <a href=http://www .yoursite.com/s tuff/script.php ?cat=$cat&a mp;limit=$limit &amp;page=$ a> $a </a> | ";
}
}

//next page: **EDIT THIS LINK PATH**

$next_page = $page + 1;
if($next_page <= $total_pages) {
echo("< ;a href=http://www .yoursite.com/s tuff/script.php ?cat=$cat&a mp;limit=$limit &amp;page=$ next_page>&l t;b>Next< /b></a> ; &gt; &gt;"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>;
}

//all done
?>

so now how can i open a databse and where are the Localhost DBname password??

answer me with info and not dumb questions.

  james said...