Hello hafdis,
Have you read our Pagination Tutorial or the Pagination Code Sample? This should get you going

yes i have been trying this, gonna try it more

Feel free to ask any questions about how it works or specific errors you may occur when you combine the code with your site.

  bs0d said...

Hi
I am not sure about this, not sure if this photo plugin is using mysql, i have not setup any mysql for the gallery, just for wordpress itself.

I got this code


Code:

<?php

@mysql_connect( $localhost, $user, $password) or die("ERRO R--CAN'T CONNECT TO SERVER";
@mysql_select_d b($database) or die("ERRO R--CAN'T CONNECT TO DB";

$limit = 25;
$query_count = "SELECT count(*) FROM table";
$result_count = mysql_query($qu ery_count);
$totalrows = mysql_num_rows( $result_count);

if(empty($page) ){
$page = 1;
}


$limitvalue = $page * $limit - ($limit);
$query = "SELECT * FROM table LIMIT $limitvalue, $limit";
$result = mysql_query($qu ery) or die("Erro r: " . mysql_error());

if(mysql_num_ro ws($result) == 0){
echo("Not hing to Display!"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>;
}

$bgcolor = "#E0E0E0 "; // light gray

echo("< ;table>&quo t;

while($row = mysql_fetch_arr ay($result)){ if ($bgcolor == "#E0E0E0 "{
$bgcolor = "#FFFFFF ";
}else{
$bgcolor = "#E0E0E0 ";
}

echo("< ;tr bgcolor=" .$bgcolor.&quo t;>n<td&g t;";
echo($row[&quo t;users"] );
echo("< ;/td>n<td >";
echo($row[&quo t;usersID" ;]);
echo("< ;/td>n</t r>";
}

echo("< ;/table>&qu ot;

if($page != 1){
$pageprev = $page--;

echo("< ;a href="$PH P_SELF&page =$pageprev&quo t;>PREV&quo t;.$limit.&quo t;</a> ";
}else{
echo("PRE V".$limit ." ";
}

$numofpages = $totalrows / $limit;

for($i = 1; $i <= $numofpages; $i++){
if($i == $page){
echo($i." ";
}else{
echo("< ;a href="$PH P_SELF?page=$i ">$i< ;/a> ";
}
}


if(($totalrows % $limit) != 0){
if($i == $page){
echo($i." ";
}else{
echo("< ;a href="$PH P_SELF?page=$i ">$i< ;/a> ";
}
}

if(($totalrows - ($limit * $page)) > 0){
$pagenext = $page++;

echo("< ;a href="$PH P_SELF?page=$pa genext"&g t;NEXT".$ limit."&l t;/a>"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>;
}else{
echo("NEX T".$limit );
}

mysql_free_resu lt($result);

?>


I hope this tutorials helps you in your pagination process, whether you copy the whole damn thing or just use bits and pieces of it. Don't forget to replace the MySQL queries with queries of your own that relate to your own database.

Until next time,
<?php exit(); The Reverend ?>

By the looks of it, you haven't setup the database for anything... unless you have a table named, "table&q uot; -

I would say you should read our pagination tutorial, you can paginate anything with it. If you read the tutorial here you will know how to use it. I can help answer questions better with my code. It looks like you just copied the code and pasted it into your site, even the author's name at the bottom. You must set the code up to read from your site.

You know I been fighting with pagination in my members galleries for an age, and I still don't get it. I don't know why it is so tuff for me. Like right now I have this working at imagerabbit:

Code:

I know, this is not the best way of doing things and this is simple right off the bat. Query the DB grab the results, and put it in columns so it is uniform. Looks nice, but some of my members have 120 photos hosted and it takes forever to get all the photos displayed.

So I have read the tutorial and it all makes sense, (Awesome Job Bs0d), but if I impliment the pagination codes where they should be, everything goes haywire.

I need thoughts suggestions, and help with this, so call me stupid, but I want to hear from you guys.

Also, this website is a help paradise, everyone should get involved to help and discuss coding just like this. Bs0d has done an outstanding job with this website and the guy really cares, so lets discuss shall we....

  gravy said...

I know, this is not the best way of doing things and this is simple right off the bat. Query the DB grab the results, and put it in columns so it is uniform. Looks nice, but some of my members have 120 photos hosted and it takes forever to get all the photos displayed.

So I have read the tutorial and it all makes sense, (Awesome Job Bs0d), but if I impliment the pagination codes where they should be, everything goes haywire.

I need thoughts suggestions, and help with this, so call me stupid, but I want to hear from you guys.

Also, this website is a help paradise, everyone should get involved to help and discuss coding just like this. Bs0d has done an outstanding job with this website and the guy really cares, so lets discuss shall we....