Paging problem in database search

[Jene200]

Hi,

I am working on a seach script, it showing me some problem on pagination.After the search it showing nextpage but when i click it it showing no results. I couldnot figure it out. Can any one help me to solve this issue..?

This is the code which i am using for searching.

Search.php

             

<form action=results20.php method=post>
<table width="259" cellspacing="0" cellpadding="3" align="center" bgcolor="#FFFFFF" style="border: 1px solid #ffffff;">
<tr bgcolor="#FFFFFF"><td width="251" height="27" align="left">
  <font size=2 face='Arial'><strong>Search by</strong></font></td>
</tr>
<tr bgcolor="#FFFFFF"><td height="100">
<p><font size="3" face="Times New Roman"><input type=radio name=search value="K">
<strong>Keyword</strong></font></p>
<p><font size="3" face="Times New Roman"><input type=radio name=search value="T">
<strong>Article Name</strong>&nbsp;</font></p>
<p><font size="3" face="Times New Roman"><input type=radio name=search value="D">
<strong>Description</strong> </font> </p></td>
</tr>
<tr bgcolor="#FFFFFF" height="27"><td align="right">
<input type=text name=search size=25>&nbsp;<input type=submit value=Search>
</td>
</tr></table>
</form>

result.php

<?php

   $pagenum = 0;

   $searchtype = $_REQUEST['searchtype'];

   $search = $_REQUEST['search'];

  if ($_REQUEST['pagenum']) 
       {
	   $pagenum = $_REQUEST['pagenum'];
	   }


   <table width="630" border="0" cellspacing="5" cellpadding="5">
    <tr>
      <td width="650" valign="top">
        <TABLE width=600 cellpadding=5 cellspacing=0 border=0>

          <tr><td width=500 align=center>

             <table cellpadding=1 cellspacing=1 border=0><tr><td bgcolor=#FFFFFF width=500 height=20 valign=center align=center>

                <table cellpadding=0 cellspacing=0 border=0><tr>

                  <td bgcolor=#FFFFFF width=498 height=18 valign=center align=left>

                   <font face="Times New Roman" size="3"><b>Search Results</b></font>

                 </td>

                </tr>
                </table>

             </td></tr></table>

          </td></tr>

          <TR>

            <TD valign=top>




Here are all the Articles containing the <?php printf($search); ?>


	          <table cellspacing=0 cellpadding=2 border=0 width="400">       


               <?php

		if ($searchtype == 'K') {

                       $sql = "select distinct articleid from articles where keywords like '%$search%'";

                    } else if ($searchtype == 'D') {

                       $sql = "select articleid from articles where description like '%$search%'";

                    } else {

                       $sql = "select articleid from articles where title like '%$search%'";

                    }

                    $result = mysql_query($sql ,$db);


                    $numrows = @mysql_numrows($result);	
					$lastpage = false;

					if ($pagenum == 0) {
					   $startrow = 0;
					} else {
					   $startrow = 25 * $pagenum;
					}

					if ($numrows < $startrow + 25) {
					   $endrow = $numrows;
					   $lastpage = true;
                    }


		if ($searchtype == 'K') {

                       $sql = "select distinct articleid from articles where keywords like '%$search%' limit $startrow,25";

                    } else if ($searchtype == 'D') {

                       $sql = "select articleid from articles where description like '%$search%' limit $startrow,25";
                    } else {
                       $sql = "select articleid from articles where title like '%$search%' limit $startrow,25";
                    }

	                $result = mysql_query($sql ,$db);

	                $acount = 1;

	                if ($myrow = @mysql_fetch_array($result)) {

	                   do {
                          $articleid[$acount] = $myrow["articleid"];
                          $acount++;
                       } while ($myrow = mysql_fetch_array($result));
                    }
                    if (count($articleid) == 0) {
                       printf("<tr><td colspan=3><p><center><FONT face=Times New Roman size=3><b>No Results Found</b></font></center></p></td></tr>");
                    } else {

                       for ($k = 1; $k <= count($articleid); $k++) {
	                      $sql = "select articleid, title, date, rating, status from articles where articleid = $articleid[$k]";
	                      $result = mysql_query($sql ,$db);
					      if ($myrow = mysql_fetch_array($result)) {
					         do {
                                                      if ($myrow["status"] == "L") {
					               printf("<tr><td>");
					               printf("<FONT face=Times New Roman, Times, serif size=3><a href=article.php?articleid=%s>%s</a>&nbsp;</font>", $myrow["articleid"], $myrow["title"]);

                                   printf("</td>");
					               printf("</tr>");


					            }

                            } while ($myrow = mysql_fetch_array($result));

                          }
                       }
                    }

                    printf($numrows);
                    printf("<tr><td align=center>");
                    if ($startrow > 0) {

					   printf("<FONT size=3><a href=results.php?pagenum=%s&search=%s>Previous Page |</a></font>",$pagenum-1, $search);
                    } else {

					   printf("");
                    }

                    if ($lastpage == false) {

					   printf("<FONT size=3><a href=results.php?pagenum=%s&search=%s>Next Page</a></font>", $pagenum+1, $search);
                    } else {

					  printf("");
                    }
                    printf("</td></tr>");

	             ?>

         </table>

            </TD>

          </TR>

        </TABLE>
      </td>
    </tr>
  </table>

[crislewis]

Can't work out from your code what you are using to do the search with what you have given here.

A xommon mistake with pagination is failing to keep track of the actual position within the dataset (or recordset) from page to page. The strategic use of LIMIT in the query must be tightly linked to 'hidden' fields in the form or session values.

[Jene200]

Thanks crislewis.
I got this script from somewhere and trying to add paging on it. I am able to limit the results to 25 per page, but when i click on next it showing the biginning 25 result from database.I couldnot figure it out the problem.

Here is the modified code.

<?php
$page = $_REQUEST['page'];
$searchtype = $_REQUEST['searchtype'];
$search= $_POST['search'];

if (!$page) {
	$page = 1;
}
if($page > 1){
	$search = $_REQUEST['search'];
}

$limit = $page * 25;
$limit = $limit - 25;

                  if ($searchtype == 'K') {
                       $sql = "select distinct articleid from article where keywords like '%$search%'";
                    }  else if ($searchtype == 'D') {
                       $sql = "select articleid from article where description like '%$search%'";
                    } else {
                       $sql = "select articleid from article where title like '%$search%'";
                    }

               $result = mysql_query($sql ,$db);
               $numrows = @mysql_numrows($result);

                  if ($searchtype == 'K') {
                       $sql = "select distinct articleid from article where keywords like '%$search%' LIMIT $limit,25";
                    }  else if ($searchtype == 'D') {
                       $sql = "select articleid from article where description like '%$search%' LIMIT $limit,25";
                    } else {
                       $sql = "select articleid from article where title like '%$search%' LIMIT $limit,25";
                    }

					if($numrows < 25){
                     $through = $numrows;
                   } else {
                     $through = $limit + 25;
                   }
                   if ($through > $numrows){
                     $through = $total;
                  }

                 if($page > 1){
                    $from = $limit +1;
                 } else {
                   $from = $limit;
                 }
                if($from == 0){
                  $from = $from +1;
                }

?>
      <table width="455" border="0" cellspacing="5" cellpadding="5">
        <tr>
          <td valign="top">    <table width=460 cellpadding=5 cellspacing=0 border=0>
            <tr>
              <td width=458 align=center><table border=0 align="left" cellpadding=1 cellspacing=1>
                  <tr>
                    <td bgcolor=#FFFFFF width=455 height=20 valign=center align=left><table cellpadding=0 cellspacing=0 border=0>
                        <tr>
                          <td bgcolor=#FFFFFF width=455 height=18 valign=center align=left><font face="Times New Roman" size="3"><b><?php printf($pagetitle); ?></b></font> </td>
                        </tr>
                    </table></td>
                  </tr>
              </table></td>
            </tr>
            <tr>
              <td valign=top width="455"><table width="455" border=0 align="left" cellpadding=2 cellspacing=0>
                  <?php	              

	                $result = mysql_query($sql ,$db);
                    $articlecount = 1;
	                if ($myrow = @mysql_fetch_array($result)) {

	                   do {
                          $articleid[$articlecount] = $myrow["articleid"];
                          $articlecount++;
                       } while ($myrow = mysql_fetch_array($result));
                    }
                    if (count($articleid) == 0) {
                       printf("<tr><td colspan=3><p><center><FONT face=Times New Roman size=3><b>No Results Found</b></font></center></p></td></tr>");
                    } else {
                       for ($k = 1; $k <= count($articleid); $k++) {
	                      $sql = "select articleid, title, date, rating, status from article where articleid = $articleid[$k]";
	                      $result = mysql_query($sql ,$db);
					      if ($myrow = mysql_fetch_array($result)) {
					         do {
					            if ($myrow["status"] == "L") {
					               printf("<tr><td>");
					               printf("<FONT face=Times New Roman, Times, serif size=3><a href=article.php?articleid=%s>%s</a>&nbsp;</font>", $myrow["articleid"], $myrow["title"]);
					              						               }
                                   printf("</td>");
					               printf("</tr>");
					            }

                            } while ($myrow = mysql_fetch_array($result));

                          }
                       }
                    }

                    printf("<tr><td align=center>");

					if ($page > 1) {
                        echo "<a href=$PHP_SELF?search=$search&page=".($page -1).">Previous</a>&nbsp;&nbsp;";
                    }

                 if (($numrows > 25) && (($limit + 25) < $numrows)) {
                     echo "<a href=$PHP_SELF?search=$search&page".($page +1).">Next</a>";
                   }

                   printf("</td></tr>");

	             ?>
          </table></td>
        </tr>
      </table></td>
    </tr>
  </table>

    </tr>
  <tr>

</table>

Please help me to solve this issue.

Thanks,
Jene.