Pagination help please?

pdn

OK here goes... I know that there are several articles written on pagination. I've read these but still am not sure how to apply to my existing script. Please assist and thanks in advance.

Here's my existing code

<?php 
$username="root";  

$password="password";  

$hostname="localhost";  

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)  

    or die("Unable to connect to Database"); 
$selected = mysql_select_db("offenderdb", $dbh) 
    or die("Unable to select offenderdb"); 
?> 
<html> 
<head> 
<title></title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit"> 
</form> 
<?php 
// Build the standard sql 
$sql = " 
    SELECT Name, AKA, DOB, Address, Conviction, Description, Victim, Comments, Pic 
    FROM sexoffenders 
"; 
// If search_text has been sent ... 
if(isset($_GET['search_text'])){  

    $sql .= " 
    	WHERE Name LIKE '%".$_GET['search_text']."%'
	OR AKA LIKE '%".$_GET['search_text']."%'
	OR Address LIKE '%".$_GET['search_text']."%'
	OR Conviction LIKE '%".$_GET['search_text']."%'
	OR Description LIKE '%".$_GET['search_text']."%'
	OR Victim LIKE '%".$_GET['search_text']."%'
	OR Comments LIKE '%".$_GET['search_text']."%'
 ORDER BY Name
"; 
}
$result = mysql_query($sql); 

if(mysql_num_rows($result) <= 0){  

  echo '<h5>NO RESULTS FOUND</h5>';  

} else { 
    while($row = mysql_fetch_array($result,MYSQL_ASSOC)){ 
?>  

<br> 
<table border="1" cellspacing="5" width="720"> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Name/AKA:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Name'}?></font></b></pre><br> 
<pre><b><font face="Verdana" size="2"><?php print $row{'AKA'}; ?></font></b></pre>  

</td><td align="center" rowspan="7" width="340"><img height="240" src="./admin/images/<?php print 

$row{'Pic'}; ?>"  border="0"><br></td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Address:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Address'}."<br>"; ?></font></b></pre>  

</td></tr> 
<tr><th align="left" width="50"><font face="Verdana" size="2" color="#0000FF">D.O.B.:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'DOB'}."<br>"; ?></font></b></pre>  

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Description:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Description'}."<br>"; ?></font></b></pre>  

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Conviction:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Conviction'}."<br>"; ?></font></b></pre>  

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Victim:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Victim'}."<br>"; ?></font></b></pre>  

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Comments:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Comments'}."<br>"; ?></font></b></pre>  

</td></tr> 
</table> 
</br> 
<?php  

    }  

    mysql_close($dbh);  

} 
?> 
</body> 
</html>

Thanks again

mrhappiness

assist != do the work for me

which threads did you read?
what did you not understand?
what exactly can't you transfer to your very problem?

pdn

I'm sorry I am very new to scripting

OK... My goal is to return 5 results per page since the rows are quite lengthy.

I know that I use a LIMIT clause i.e. LIMIT 5

and that I have to code finding required number of pages and then hyperlink to the pages.

I'm not sure where in my script to place these Items.

Again I'm very new if you have some suggestions please let me know.

Thanks so much

Matt_Kindig

If you want to retrieve both the number of results found as well as limiting the number to 5, you will probably have to do two queries. The first would be like:

$sql="SELECT Name FROM sexoffenders";
// this query gets the number of rows in the result
$sql . = "WHERE COUNT(*) LIKE '%".$_GET['search_text']."%'
    OR AKA LIKE '%".$_GET['search_text']."%'
    OR Address LIKE '%".$_GET['search_text']."%'
    OR Conviction LIKE '%".$_GET['search_text']."%'
    OR Description LIKE '%".$_GET['search_text']."%'
    OR Victim LIKE '%".$_GET['search_text']."%'
    OR Comments LIKE '%".$_GET['search_text']."%'
";
$results=mysql_query($sql);
$numRows=$results[0];
$numPages = ceil($numRows / 5);

The second query would be used to retrieve the next five rows, starting at $offset. It is probably easiest to pass $offset in the URL (using the $_GET parameter), so that your links can be like http://www.mydomain.com/page.php?offest=0,
http://www.mydomain.com/page.php?offset=5,
etc.

$sql="SELECT Name, AKA, DOB, Address, Conviction, Description, Victim, Comments, Pic FROM sexoffenders";
// this query gets the next five rows in the result
$sql1 . = "WHERE COUNT(*) LIKE '%".$_GET['search_text']."%'
    OR AKA LIKE '%".$_GET['search_text']."%'
    OR Address LIKE '%".$_GET['search_text']."%'
    OR Conviction LIKE '%".$_GET['search_text']."%'
    OR Description LIKE '%".$_GET['search_text']."%'
    OR Victim LIKE '%".$_GET['search_text']."%'
    OR Comments LIKE '%".$_GET['search_text']."%'
"  ORDER BY Name LIMIT $offset, 5";
$results=mysql_query($sql2);

EDIT: I didn't check all the single and double quote marks to make sure they are correct, so be careful before you paste.

pdn

OK... I built the script to include pagination last night but I am having some strange problems with it. For one thing my Prev 123 Next links are not active links. And also when I use the LIMIT clause my search stops functioning.

I am enclosing the script that I am currently using. Any corrective criticism would be appreciated. Thanks in advance

<?php 
$username="root";  

$password="password";  

$hostname="localhost";  

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)  

    or die("Unable to connect to Database"); 
$selected = mysql_select_db("offenderdb", $dbh) 
    or die("Unable to select offenderdb"); 
?>
<html> 
<head> 
<title></title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit" value="Search"> 
</form>

<?php
// set limit per page
     $limit = 5;
     $query_count    = "SELECT count(*) FROM sexoffenders"; 
     $result_count   = mysql_query($query_count);
     $totalrows  = mysql_num_rows($result_count);

if(empty($page)){     

        $page = 1;         } 

$limitvalue = $page * $limit - ($limit); 

// Build the standard sql 
$sql = " 
    SELECT * FROM sexoffenders LIMIT $limitvalue, $limit
"; 
// If search_text has been sent ... 
if(isset($_GET['search_text'])){  

    $sql .= " 
    	WHERE Name LIKE '%".$_GET['search_text']."%'
	OR AKA LIKE '%".$_GET['search_text']."%'
	OR Address LIKE '%".$_GET['search_text']."%'
	OR Conviction LIKE '%".$_GET['search_text']."%'
	OR Description LIKE '%".$_GET['search_text']."%'
	OR Victim LIKE '%".$_GET['search_text']."%'
	OR Comments LIKE '%".$_GET['search_text']."%'
 ORDER BY Name
"; 
}



$result = mysql_query($sql); 

 if(mysql_num_rows($result) <= 0){  

     echo '<h5>NO RESULTS FOUND</h5>';  

} 
 else { 
     while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{ 


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

    echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> "); 
}else{ 
    echo("PREV".$limit." "); 
} 

$numofpages = $totalrows / $limit; 

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


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

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

    echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>"); 
}else{ 
    echo("NEXT".$limit); 
} 


?>

Matt_Kindig

Well, I see one problem here:

$query_count    = "SELECT count(*) FROM sexoffenders"; 
     $result_count   = mysql_query($query_count);
     $totalrows  = mysql_num_rows($result_count);

You are doing a COUNT query, which retrieves the total number of entries in the database. You are then using mysql_num_rows() to get the number of rows in this result, which would just be one (since you have only retrieved teh number of results). You should use the method I posted previously, i.e.

$totalrows=$result_count[0];

Do that and then let me know what additional errors you have.

pdn

OK... I made the change suggested. The pagination links are still not active, and they display like this

PREV5 NEXT5

Then when I click the Search function the following error displays

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\csweb\PHP_test\test1.php on line 58

NO RESULTS FOUND

Thanks for the help 🙂

Matt_Kindig

Wait a sec...you never set the $page variable. Add this to the top of the script.

$page=$_GET['page'];

Let us know if this helps.

scross

Here is some code that should work:

<?php  

$username="root";
$password="password";   

$hostname="localhost";   

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)   

    or die("Unable to connect to Database");  

$selected = mysql_select_db("offenderdb", $dbh)  

    or die("Unable to select offenderdb");  

?> 
<html> 
<head> 
<title>Title</title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit" value="Search"> 
</form> 

<?php 
// set limit per page 
     $limit = 5; 

$page=$_GET['page'];
if(!$page){      

        $page = 1;
}  

$max = $page * $limit; 
$min = $max - $limit;

// Build the standard sql 
$sql = " SELECT * FROM sexoffenders";  

// If search_text has been sent ... 
if(isset($_GET['search_text'])){   

    $sql .= " WHERE Name LIKE '%".$_GET['search_text']."%' 
    OR AKA LIKE '%".$_GET['search_text']."%' 
    OR Address LIKE '%".$_GET['search_text']."%' 
    OR Conviction LIKE '%".$_GET['search_text']."%' 
    OR Description LIKE '%".$_GET['search_text']."%' 
    OR Victim LIKE '%".$_GET['search_text']."%' 
    OR Comments LIKE '%".$_GET['search_text']."%' 
ORDER BY Name";  

} 
$query=mysql_query($sql);
$totalrows=mysql_num_rows($query);
$sql .= " LIMIT $min, $max";
$result=mysql_query($sql);

 if(mysql_num_rows($result) <= 0){   

     echo '<h5>NO RESULTS FOUND</h5>';   

}else{
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { 
?>
<br /
<table border="1" cellspacing="5" width="720"> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Name/AKA:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Name'}?></font></b></pre><br> 
<pre><b><font face="Verdana" size="2"><?php print $row{'AKA'}; ?></font></b></pre>   

</td><td align="center" rowspan="7" width="340"><img height="240" src="./admin/images/<?php print  

$row{'Pic'}; ?>"  border="0"><br></td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Address:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Address'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="50"><font face="Verdana" size="2" color="#0000FF">D.O.B.:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'DOB'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Description:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Description'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Conviction:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Conviction'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Victim:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Victim'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Comments:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Comments'}."<br>"; ?></font></b></pre>   

</td></tr> 
</table> 
<br />
<?php
}
echo "<br />";
$prevpage=$page-1;
$nextpage=$page+1;
$numpages=ceil($totalrows/$limit);
if($page != 1){
echo "<a href='".$_SERVER['PHP_SELF']."?search_text=".$_GET['search_text']."&page=".$prevpage."'>PREV ".$limit."</a> ";
}else{
echo "PREV ".$limit." ";
}
echo " Search Returned ".$numpages." Pages  ";
if($page != $numpages){
echo "<a href='".$_SERVER['PHP_SELF']."?search_text=".$_GET['search_text']."&page=".$nextpage."'>NEXT ".$limit."</a>";
}else{
echo "NEXT ".$limit;
}
mysql_close();
?>
</body>
</html>

If you experience any problems just post and I will look into this properly. Also using LIKE in a mysql query to make a search engine is not effective and if you want I will provide with an accurate helpful search engine.
Scross

pdn

Thanks very much... I'm getting closer to having everything in place.

I used the code you supplied this is the response I'm getting.

Notice: Undefined index: page in D:\csweb\PHP_test\test1.php on line 26

everything displays correctly on the first page though. After the first page when I click Next5 it displays next 10 results. When I click it again it displays next 15 results and so on...

Thanks again.

Matt_Kindig

To get rid of the notice, you can replace this code:

$page=$_GET['page'];
if(!$page){      

        $page = 1;
}

with this:

if (isset($_GET['page'])) {
  $page=$_GET['page'];
} else { 
  $page=1;
}

That should eliminate the error.

scross

Can you give us the url of your script so we can have a look.

Here is some better code:

<?php  

$username="root";
$password="password";   

$hostname="localhost";   

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)   

    or die("Unable to connect to Database");  

$selected = mysql_select_db("offenderdb", $dbh)  

    or die("Unable to select offenderdb");  

?> 
<html> 
<head> 
<title>Title</title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit" value="Search"> 
</form> 

<?php 
// set limit per page 
     $limit = 5; 

   if (isset($_GET['page'])) { 
      $page=$_GET['page']; 
   } else {  

      $page=1; 
   }  


$max = $page * $limit; 
$min = $max - $limit;

// Build the standard sql 
$sql = " SELECT * FROM sexoffenders";  

// If search_text has been sent ... 
if(isset($_GET['search_text'])){   

    $sql .= " WHERE Name LIKE '%".$_GET['search_text']."%' 
    OR AKA LIKE '%".$_GET['search_text']."%' 
    OR Address LIKE '%".$_GET['search_text']."%' 
    OR Conviction LIKE '%".$_GET['search_text']."%' 
    OR Description LIKE '%".$_GET['search_text']."%' 
    OR Victim LIKE '%".$_GET['search_text']."%' 
    OR Comments LIKE '%".$_GET['search_text']."%' 
ORDER BY Name";  

} 
$query=mysql_query($sql);
$totalrows=mysql_num_rows($query);
$sql .= " LIMIT $min, $max";
$result=mysql_query($sql);

 if(mysql_num_rows($result) <= 0){   

     echo '<h5>NO RESULTS FOUND</h5>';   

}else{
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) { 
?>
<br /
<table border="1" cellspacing="5" width="720"> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Name/AKA:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Name'}?></font></b></pre><br> 
<pre><b><font face="Verdana" size="2"><?php print $row{'AKA'}; ?></font></b></pre>   

</td><td align="center" rowspan="7" width="340"><img height="240" src="./admin/images/<?php print  

$row{'Pic'}; ?>"  border="0"><br></td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Address:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Address'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="50"><font face="Verdana" size="2" color="#0000FF">D.O.B.:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'DOB'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Description:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Description'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Conviction:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Conviction'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Victim:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Victim'}."<br>"; ?></font></b></pre>   

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Comments:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Comments'}."<br>"; ?></font></b></pre>   

</td></tr> 
</table> 
<br />
<?php
}
echo "<br />";
$prevpage=$page-1;
$nextpage=$page+1;
$numpages=ceil($totalrows/$limit);
if(!$numpages){
$numpages=1;
}
if($page != 1){
echo "<a href='".$_SERVER['PHP_SELF']."?search_text=".$_GET['search_text']."&page=".$prevpage."'>PREV ".$limit."</a> ";
}else{
echo "PREV ".$limit." ";
}
echo " ---Search Returned ".$numpages." Pages---  ";
if($page != $numpages){
echo "<a href='".$_SERVER['PHP_SELF']."?search_text=".$_GET['search_text']."&page=".$nextpage."'>NEXT ".$limit."</a>";
}else{
echo "NEXT ".$limit;
}
mysql_close();
?>
</body>
</html>

pdn

Here is the URL for the test site I am working on...

http://www.csweb.net/php_test/test1.php?search_text=

The last bit of code posted by scross seems to work well with the exception of it is still adding five to each page.

Thanks to all so much for the help. This is by far the best forum out there 🙂

scross

This might work better:
If it keeps adding 5 results to your search then it is something to do with your mysql since it works fine on many of my own. If it doesn't work I will change it so php limits it. I have used this on many occasions and it works just as well.

<?php   

$username="root"; 
$password="password";    

$hostname="localhost";    

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)    

    or die("Unable to connect to Database");   

$selected = mysql_select_db("offenderdb", $dbh)   

    or die("Unable to select offenderdb");   

?>  

<html> 
<head> 
<title>Title</title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit" value="Search"> 
</form> 

<?php  

// set limit per page 
     $limit = 5;  

   if (isset($_GET['page'])) {  

      $page=$_GET['page'];  

   } else {   

      $page=1;  

   }


$max = $page * $limit;  
$min = $max - $limit; 

// Build the standard sql 
$sql = " SELECT * FROM sexoffenders";   

// If search_text has been sent ... 
if(isset($_GET['search_text'])){    

    $sql .= " WHERE Name LIKE '%".$_GET['search_text']."%' 
    OR AKA LIKE '%".$_GET['search_text']."%' 
    OR Address LIKE '%".$_GET['search_text']."%' 
    OR Conviction LIKE '%".$_GET['search_text']."%' 
    OR Description LIKE '%".$_GET['search_text']."%' 
    OR Victim LIKE '%".$_GET['search_text']."%' 
    OR Comments LIKE '%".$_GET['search_text']."%' 
ORDER BY Name";   

}  

$query=mysql_query($sql); 
$totalrows=mysql_num_rows($query); 
$sql .= " LIMIT $min,$max"; 
$result=mysql_query($sql); 

 if(mysql_num_rows($result) <= 0){    

     echo '<h5>NO RESULTS FOUND</h5>';    

}else{ 
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {  

?> 
<br / 
<table border="1" cellspacing="5" width="720"> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Name/AKA:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Name'}?></font></b></pre><br> 
<pre><b><font face="Verdana" size="2"><?php print $row{'AKA'}; ?></font></b></pre>    

</td><td align="center" rowspan="7" width="340"><img height="240" src="./admin/images/<?php print   

$row{'Pic'}; ?>"  border="0"><br></td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Address:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Address'}."<br>"; ?></font></b></pre>    

</td></tr> 
<tr><th align="left" width="50"><font face="Verdana" size="2" color="#0000FF">D.O.B.:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'DOB'}."<br>"; ?></font></b></pre>    

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Description:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Description'}."<br>"; ?></font></b></pre>    

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Conviction:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Conviction'}."<br>"; ?></font></b></pre>    

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Victim:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Victim'}."<br>"; ?></font></b></pre>    

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Comments:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Comments'}."<br>"; ?></font></b></pre>    

</td></tr> 
</table> 
<br /> 
<?php 
} 
echo "<br />"; 
$prevpage=$page-1; 
$nextpage=$page+1; 
$numpages=ceil($totalrows/$limit); 
if(!$numpages){ 
$numpages=1; 
} 
if($page != 1){ 
echo "<a href='".$_SERVER['PHP_SELF']."?";
if(isset($_GET[search_text])){
echo "search_text=".$_GET['search_text']."&";
}
echo "page=".$prevpage."'>PREV ".$limit."</a> "; 
}else{ 
echo "PREV ".$limit." "; 
} 
echo " ---Search Returned ".$numpages." Pages---  "; 
if($page != $numpages){ 
echo "<a href='".$_SERVER['PHP_SELF']."?";
if(isset($_GET[search_text])){
echo "search_text=".$_GET['search_text']."&";
}
echo "page=".$nextpage."'>NEXT ".$limit."</a> "; 
}else{ 
echo "NEXT ".$limit; 
} 
mysql_close(); 
?> 
</body> 
</html>

pdn

It's really close... It only displays 5 results per page but only two problems

1) The first page looks great... following pages change the order but contain the same data as first page. In other words it doesn't display the data contained on rows 6-10, 11-15, and so on...

2) the link for next displays the entire string D:\csweb\PHP_test\test1.php on line 110 page=2'>NEXT 5

is there a way to display only the text NEXT 5?

I think the trouble is in the following code

echo "<br />";  

$prevpage=$page-1;  

$nextpage=$page+1;  

$numpages=ceil($totalrows/$limit);  

if(!$numpages){  

$numpages=1;  

}  

if($page != 1){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET[search_text])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$prevpage."'>PREV ".$limit."</a> ";  

}else{  

echo "PREV ".$limit." ";  

}  

echo " ---Search Returned ".$numpages." Pages---  ";  

if($page != $numpages){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET[search_text])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$nextpage."'>NEXT ".$limit."</a> ";  

}else{  

echo "NEXT ".$limit;  

}  

mysql_close();
}

pdn

Upon closer examination when I click Next it is echoing the following link over and over

D:\csweb\PHP_test\test1.php

scross

In that bit try this:

echo "<br />";  

$prevpage=$page-1;  

$nextpage=$page+1;  

$numpages=ceil($totalrows/$limit);  

if(!$numpages){  

$numpages=1;  

}  

if($page != 1){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET['search_text'])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$prevpage."'>PREV ".$limit."</a> ";  

}else{  

echo "PREV ".$limit." ";  

}  

echo " ---Search Returned ".$numpages." Pages---  ";  

if($page != $numpages){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET['search_text'])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$nextpage."'>NEXT ".$limit."</a> ";  

}else{  

echo "NEXT ".$limit;  

}  

mysql_close();
}

pdn

That works great only problem now is just the adding 5 to each page. You mentioned it may be a problem with mysql do you have any ideas where I might look? Also you said it can be limited with php?

Thanks mucho!

pdn

btw... I also noticed that when I get to about the 4th page or so it starts subtracting 5 from the results...

it starts by displaying 5, then 10, then 15, then 20, then 17, then 12, then 7, then 2

Any ideas???

Thanks

scross

Try this:

<?php    

$username="root";  

$password="password";     

$hostname="localhost";     

// Connect to Database 
$dbh = mysql_connect($hostname, $username, $password)     

    or die("Unable to connect to Database");    

$selected = mysql_select_db("offenderdb", $dbh)    

    or die("Unable to select offenderdb");    

?>   

<html> 
<head> 
<title>Title</title> 
</head> 
<body> 
<!-- Search form --> 
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get"> 
<input type="text" name="search_text" size="50" maxlength="50"><input type="submit" value="Search"> 
</form> 

<?php   

// set limit per page 
     $limit = 5;   

   if (isset($_GET['page'])) {   

      $page=$_GET['page'];   

   } else {    

      $page=1;   

   } 


$max = $page * $limit;   
$min = $max - $limit;  

// Build the standard sql 
$sql = " SELECT * FROM sexoffenders";    

// If search_text has been sent ... 
if(isset($_GET['search_text'])){     

    $sql .= " WHERE Name LIKE '%".$_GET['search_text']."%' 
    OR AKA LIKE '%".$_GET['search_text']."%' 
    OR Address LIKE '%".$_GET['search_text']."%' 
    OR Conviction LIKE '%".$_GET['search_text']."%' 
    OR Description LIKE '%".$_GET['search_text']."%' 
    OR Victim LIKE '%".$_GET['search_text']."%' 
    OR Comments LIKE '%".$_GET['search_text']."%' 
ORDER BY Name";    

}   

$query=mysql_query($sql);  

$totalrows=mysql_num_rows($query);  

$result=mysql_query($sql);  

 if(mysql_num_rows($result) <= 0){     

     echo '<h5>NO RESULTS FOUND</h5>';     

}else{
$count=1;
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
if(($count>$min) && ($count<=$max)){
?>  

<br / 
<table border="1" cellspacing="5" width="720"> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Name/AKA:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Name'}?></font></b></pre><br> 
<pre><b><font face="Verdana" size="2"><?php print $row{'AKA'}; ?></font></b></pre>     

</td><td align="center" rowspan="7" width="340"><img height="240" src="./admin/images/<?php print    

$row{'Pic'}; ?>"  border="0"><br></td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Address:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Address'}."<br>"; ?></font></b></pre>     

</td></tr> 
<tr><th align="left" width="50"><font face="Verdana" size="2" color="#0000FF">D.O.B.:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'DOB'}."<br>"; ?></font></b></pre>     

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Description:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Description'}."<br>"; ?></font></b></pre>     

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Conviction:</font></th> 
<td> 
<pre><b><font face="Verdana" size="2"><?php print $row{'Conviction'}."<br>"; ?></font></b></pre>     

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Victim:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Victim'}."<br>"; ?></font></b></pre>     

</td></tr> 
<tr><th align="left" width="100"><font face="Verdana" size="2" color="#0000FF">Comments:</font></th> 
<td><pre><b><font face="Verdana" size="2"><?php print $row{'Comments'}."<br>"; ?></font></b></pre>     

</td></tr> 
</table> 
<br /> 
<?php  

}
}
echo "<br />";  

$prevpage=$page-1;  

$nextpage=$page+1;  

$numpages=ceil($totalrows/$limit);  

if(!$numpages){  

$numpages=1;  

}  

if($page != 1){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET['search_text'])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$prevpage."'>PREV ".$limit."</a> ";  

}else{  

echo "PREV ".$limit." ";  

}  

echo " ---Search Returned ".$numpages." Pages---  ";  

if($page != $numpages){  

echo "<a href='".$_SERVER['PHP_SELF']."?"; 
if(isset($_GET['search_text'])){ 
echo "search_text=".$_GET['search_text']."&"; 
} 
echo "page=".$nextpage."'>NEXT ".$limit."</a> ";  

}else{  

echo "NEXT ".$limit;  

}  

mysql_close();  

?>  

</body> 
</html>