anyone help with pages? I'm so close!

anthill

I think i'm close to my answer but I just can't quite figure it out. Anyway, i'm pulling result from a table 5 at a time and wanna have a next and previous button. This is working fine, next I wanted to add a number for each page, which I have also done, but I dunno how to make each page number direct to the right set of results. heres the code:

<?

$db = mysql_connect("localhost", "user","pass");
mysql_select_db("database",$db);

if(!$rowstart) $rowstart=0;

$result = mysql_query("SELECT * FROM links LIMIT $rowstart,5");
$result2 = mysql_query("SELECT * FROM links");

   while ($myrow = mysql_fetch_row($result)) 
       {
        for ($i=0; $i<mysql_num_fields($result); $i++)
        echo $myrow[$i] . " ";
        echo "<br>";
       }

 if ($rowstart>$numrows)
   {
    $back = $rowstart-5;
     echo "<a href='thispage.php?rowstart=".$back."'>< Previous</a>"; 
   }      
   echo "|";
   $numrows=mysql_num_rows($result2); 

   if($rowstart+5<$numrows)  
   {
    $forward = $rowstart+5;
    echo "<a href='thispage.php?rowstart=".$forward."'> Next Page > </a>"; 
   }   

   $count = 0;
   $pages = $numrows/5;

   for($count=0; $count<$pages; $count++)
      { 
      echo " <a href='thispage.php?rowstart='>".$count."</a> ";
      }

?>

So lets say there are 90 results in the database, i'd get:

result 1
result 2
result 3
result 4
result 5
Next > 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

So if i click on 6, it i will show the results of limit 30.

Hope you understand, please help!

thanks

Ant

abnfire

i did not understand what was your question. let say you click on page 15. now what you want to do with links here?
give me more idea what you want.

anthill

so if i click on 15 it would display page 15. Page 15 displaying something like:

result 75
result 76
result 77
result 78
result 79
result 80
< Previous | Next > 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

so each number is just a simple link to each set of 5 results limited in the query. Just like a the bottom of the forum it says
Next 1 2 3 ...

j-mag

Okay, what I'm confused about is whether you really want a page 0 or not. If so, then you want page 0 to show 0-4, page 1 to show 5-9, etc, right? (If mySQL starts at row 0). That's easy -- it's page-number 5. If it starts at row 1, then it's (page-number 5) + 1 (you shouldn't need parentheses because muliplication should take precedence).

Now, if you don't want a page 0, it's a bit tougher. You take (page-number - 1) 5. So, for page 6, it would be (6 - 5) 5 (which would start you on row 25 -- if you start at row 0 this is right, if you start at row 1, you need to add one).

The reason I don't know about row 0/row 1 is that I'm a PostgreSQL user and it's row 0 in PostgreSQL, but I didn't want to make an unwarranted assumption.

anthill

thanks j-mag, i got it sorted it works fine, only any ideas how to make the page number i'm on different to the rest? here's the working code so far:

<?php
$db = mysql_connect("localhost", "user","pass");

mysql_select_db("texturelinks",$db);

if(!$rowstart) $rowstart=0;

$result = mysql_query("SELECT * FROM soundlinks LIMIT $rowstart,5");
$result2 = mysql_query("SELECT * FROM soundlinks");

   while ($myrow = mysql_fetch_row($result)) 
       {
        for ($i=0; $i<mysql_num_fields($result); $i++)
        echo $myrow[$i] . " ";
        echo "<br>";
       }

 if ($rowstart>$numrows)

   {
           $back = $rowstart-5;
           echo "<a href='page.php?rowstart=".$back."'>< Previous Page</a>"; 
   } 

   echo "|";

   $numrows=mysql_num_rows($result2); 

   if($rowstart+5<$numrows)  

   {
          $forward = $rowstart+5;
          echo "<a href='page.php?rowstart=".$forward."'> Next Page > </a>"; 
   }   

   $count = 1;
   $new = 0;
   $pages = ($numrows/5) + 1;

   for($count=1; $count<$pages; $count++ . $new+=5)
      { 
      echo " <a href='texturelist.php?rowstart=".$new."'>".$count."</a> ";   
      }

So this would display

result 1
result 2
result 3
result 4
result 5
Next > 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

So, any ideas how to make the page i'm on stand out like:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Thanks

Ant

anthill

well that was easy enough 🙂

just

for($count=1; $count<$pages; $count++ . $new+=5)
          { 

        if($new == $rowstart)
        {
        echo " <a href='page.php?rowstart=".$new."'>".$count."</a> ";
        }
        else
        {
        echo " <a href=page.php?rowstart=".$new."' style='text-decoration: none;'>".$count."</a> ";
        }

      }

can sleep soundly now, cheers

Ant