title: Script forgets search keyword
body: <p>When I go to the next page(from index.php to index.php?page=2), the script forgets search keyword "<code>for example country=US</code>" and shows in the next page default option <code>(country=)</code>. Then I  also  tried to add(WHERE <code>country</code>='"<code>.mysql_real_escape_string($_GET['country']</code>)."') ,but in this way I think this line doesn't work: </p>
  
  <pre><code>foreach($_POST as $key =&gt; $value)
  {
    $clean[$key] = mysql_real_escape_string(trim($value));
  }
  $name=$clean['name'];
  $country=$clean['country'];
  $ip=$clean['ip'];
  $map=$clean['map'];
  $o="AND";
  </code></pre>
  
  <p>Sorry for the mess in the script, because I have collected it from the parts what I have found in the web and etc. So I still don't have enough skills to find out whats wrong. Thanks for any suggestion.</p>
  
  <pre><code>&lt;?  
  include("conf.php");
  
  foreach($_POST as $key =&gt; $value)
  {
    $clean[$key] = mysql_real_escape_string(trim($value));
  }
  $name=$clean['name'];
  $country=$clean['country'];
  $ip=$clean['ip'];
  $map=$clean['map'];
  $o="AND";
                   $rest="";
                   $text="Keywords : ";
  
  
                       if($name!="")
                       {
                          if($rest=="")
                              {
                           $rest.=" where name like '%$name%'";
                           $text.="Name like $name ";
                           }
                           else {
                              $rest.="$o where fname like '%$name%' or mname like '%$name%' or lname like '%$name%' ";
                               $text.="Name like $name ";
                           }
                       }
                       if($country!="")
                       {
                          if($rest=="")
                              {
                                  $rest.="where country='$country' ";
                                  $text.="Country = $country";
                              }
                              else
                              {
                              $rest.=" $o country='$country' ";
                              $text.=", Country = $country";
                              }
                       }
  
                        if($ip!="")
                       {
                          if($rest=="")
                              {
                                  $rest.="where ip = '$ip' ";
                                  $text.="Ip Address = $ip ";
                              }
                              else
                              {
                              $rest.=" $o  ip = '$ip' ";
                              $text.=", Ip Address = $ip ";
                              }
                       }
                       if($port!="")
                       {
                          if($rest=="")
                              {
                                  $rest.="where port = '$port' ";
                                  $text.="Port = $port ";
                              }
                              else
                              {
                              $rest.=" $o  port = '$port' ";
                              $text.=", Port = $port ";
                              }
                       }
  
                       if($map!="")
                       {
                          if($rest=="")
                              {
                                  $rest.="where map = '$map' ";
                                  $text.="Map = $map";
                              }
                              else
                              {
                              $rest.=" $o  map = '$map' ";
                              $text.=", Map = $map";
                              }
                       }
                      if($rest!="")
                      {
                      $rest=$rest;
                      }
                      else
                      {
                          //die("Enter Search Parameter&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;");
                      }
      $sql="select $search.* from $search $rest order by id"; 
      $result=mysql_query($sql,$connection) or die(mysql_error());            
      $num=mysql_num_rows($result);
      $adjacents = 3;
      $limit = 10; 
      $query = "SELECT COUNT(*) as num FROM $search";
      $total_pages = mysql_fetch_array(mysql_query($query));
      $total_pages = $num;
      /* Setup vars for query. */
      $targetpage = "index.php";  //your file name  (the name of this file)
                                  //how many items to show per page
      $page = $_GET['page'];
      if($page) 
          $start = ($page - 1) * $limit;          //first item to display on this page
      else
          $start = 0;                             //if no page var is given, set start to 0
  
      /* Get data. */
      $sql = "select $search.* from $search $rest order by id LIMIT $start, $limit";
      $result = mysql_query($sql);
  
      /* Setup page vars for display. */
      if ($page == 0) $page = 1;                  //if no page var is given, default to 1.
      $prev = $page - 1;                          //previous page is page - 1
      $next = $page + 1;                          //next page is page + 1
      $lastpage = ceil($total_pages/$limit);      //lastpage is = total pages / items per page, rounded up.
      $lpm1 = $lastpage - 1;  
  
      /* 
          Now we apply our rules and draw the pagination object. 
          We're actually saving the code to a variable in case we want to draw it more than once.
      */
      $pagination = "";
      if($lastpage &gt; 1)
      {   
          $pagination .= "&lt;div class=\"pagination\"&gt;";
          //previous button
          if ($page &gt; 1) 
              $pagination.= "&lt;a href=\"$targetpage?page=$prev\"&gt;« previous&lt;/a&gt;";
          else
              $pagination.= "&lt;span class=\"disabled\"&gt;« previous&lt;/span&gt;"; 
  
          //pages 
          if ($lastpage &lt; 7 + ($adjacents * 2))   //not enough pages to bother breaking it up
          {   
              for ($counter = 1; $counter &lt;= $lastpage; $counter++)
              {
                  if ($counter == $page)
                      $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                  else
                      $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                 
              }
          }
          elseif($lastpage &gt; 5 + ($adjacents * 2))    //enough pages to hide some
          {
              //close to beginning; only hide later pages
              if($page &lt; 1 + ($adjacents * 2))        
              {
                  for ($counter = 1; $counter &lt; 4 + ($adjacents * 2); $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                 
                  }
                  $pagination.= "...";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";       
              }
              //in middle; hide some front and some back
              elseif($lastpage - ($adjacents * 2) &gt; $page &amp;&amp; $page &gt; ($adjacents * 2))
              {
                  $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                  $pagination.= "...";
                  for ($counter = $page - $adjacents; $counter &lt;= $page + $adjacents; $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                 
                  }
                  $pagination.= "...";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lpm1\"&gt;$lpm1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=$lastpage\"&gt;$lastpage&lt;/a&gt;";       
              }
              //close to end; only hide early pages
              else
              {
                  $pagination.= "&lt;a href=\"$targetpage?page=1\"&gt;1&lt;/a&gt;";
                  $pagination.= "&lt;a href=\"$targetpage?page=2\"&gt;2&lt;/a&gt;";
                  $pagination.= "...";
                  for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter &lt;= $lastpage; $counter++)
                  {
                      if ($counter == $page)
                          $pagination.= "&lt;span class=\"current\"&gt;$counter&lt;/span&gt;";
                      else
                          $pagination.= "&lt;a href=\"$targetpage?page=$counter\"&gt;$counter&lt;/a&gt;";                 
                  }
              }
          }
  
          //next button
          if ($page &lt; $counter - 1) 
              $pagination.= "&lt;a href=\"$targetpage?page=$next\"&gt;next »&lt;/a&gt;";
          else
              $pagination.= "&lt;span class=\"disabled\"&gt;next »&lt;/span&gt;";
          $pagination.= "&lt;/div&gt;\n";       
      }
  
      echo "&lt;div align=left&gt;$text&lt;/div&gt;";
      echo "&lt;table align=center&gt; 
      &lt;div align=left&gt;&lt;tr&gt;\n
      &lt;td&gt;Records Found: $num &amp;nbsp; \n
      &lt;td&gt; &amp;nbsp;\n
  
  &lt;/tr&gt;\n
  &lt;tr&gt; \n&lt;/div&gt;";
  $counter=0;
  while($row=mysql_fetch_array($result))
  { 
  </code></pre>