[RESOLVED] another post about search + pagination

darkangel2001lv

Having a problem with my script. What is happening is when you enter your search term and hit search page refreshes and only displays the search form NO results. I then added a line to check to see if search term ( $var = $_GET['SearchTerm'] ) was being passed from search form to processing script and it was. Also connection to database checked out. I have searched Google and this forum for days which got me as far as i have gotten, but am still not seeing what is wrong. Any help would be wonderful.

$query is suppose to select column named links and keywords and display data in link column as result. Based on my searching of the script i think the problem is somewhere in the $query any ideas?
Search Form


<form name="form" action="search.php" method="GET">
<div align="center">
<p>
  <input name="SearchTerm" type="text" value="Enter Your Search Term........." size="50" />
  <input type="submit" name="Submit" value="Search" />
<br>
  Quick Link: View Whole Grain products, click <a href="wg-products.php">here</a></p>
</div>
</form>

and processing script


<?php

  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "This is the search query: ". $var; //just checking to see if search term is being passed

  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search term!</p>";
  exit;
  }

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results.Please try again. If you need help please <a href='../help/search-help.php'>click here.</a></p>";

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
echo "Results";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
  }
?>

bradgrafelman

All of the code which appears to be processing the results of the SQL query are contained within an if() statement that only evaluates to true if the query returned no rows. In other words, the logic that dictates whether all of your code gets executed doesn't make much sense.

Also: your code is vulnerable to SQL injection attacks and/or just plain SQL errors. Reference: [man]security.database.sql-injection[/man]

And finally: Stop Using the MySQL Extension!

darkangel2001lv

bradgrafelman;11018023 wrote:
All of the code which appears to be processing the results of the SQL query are contained within an if() statement that only evaluates to true if the query returned no rows. In other words, the logic that dictates whether all of your code gets executed doesn't make much sense.

Also: your code is vulnerable to SQL injection attacks and/or just plain SQL errors. Reference: [man]security.database.sql-injection[/man]

And finally: Stop Using the MySQL Extension!

Ok understand SQL injection, however this script is going on a internal server on a network with no web access so SQL injection is not an issue. Will read up on that tho for my other projects.
Based on your reply worked with script some and now will display results, however is not passing results pass page 1.
As well is displaying (code below) reguardless if there is a result or not..... ??


if ($numrows == 0); 
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a></p>";

Full Reworked Script



  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot;";   // display what the person searched for
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=8; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search term!</p>";
  exit;
  }

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0); 
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// begin to show results set
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$title <br />" ;
  $count++ ;
  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "<br /><a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 8</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "<br /><a href=\"$PHP_SELF?s=$news&q=$var\">Next 8 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p><br />Showing results $b to $a of $numrows</p>";
  }

darkangel2001lv

I have spent the whole day searching books i have, web and this forum with not much luck, maybe i am searching for the wrong thing. I have figured out that problem lies with search var not being passed to the other pages but can not see where exactly the problem is. Can anyone shine some light on this ?

Second issue is stumping me as well why would this echo even tho result results are being displayed. this one i don't know where to begin searching for a solution. Any help would be welcome.

if ($numrows == 0); 
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a></p>";

dalecosp

Do the other pages use the same code? Is the variable $GET['q'], or $GET['SearchTerm']?

darkangel2001lv

dalecosp;11018427 wrote:
Do the other pages use the same code? Is the variable $GET['q'], or $GET['SearchTerm']?

variable is $_GET['SearchTerm']

Here is my setup: Updated Scripts after working with them

search.php <----- form


<form name="form" action="process.php" method="GET">
<div align="center">
<p>
<input name="SearchTerm" type="text" value="Enter Your Search Term........." size="50" />
<input type="submit" name="Submit" value="Search" />
<br>
Quick Link: View Whole Grain products, click <a href="wg-products.php">here</a></p>
</div>
</form>

and

page two ( process.php )


<?php

  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot;";   // display what the person searched for
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=8; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search term!</p>";
  exit;
  }

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0); 
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// begin to show results set
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$title <br />" ;

  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "<br /><a href=\"search.php?s=$prevs&q=$var\">; 
  Prev 8</a>;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "<br /><a href=\"search.php?s=$news&q=$var\">Next 8</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p><br />Showing results $b to $a of $numrows</p>";
  }
?>

bradgrafelman

For one, this:

if ($numrows == 0);

is the same as this:

// do absolutely nothing

due to the semicolon after the if() statement.

Second, you still have the same problem I mentioned - all of your code is inside the if() statement that checks if there are ZERO results. So even if you get rid of the semicolon that doesn't belong, your code will execute none of your code after you execute the SQL query and store the number of rows inside $numrows.

darkangel2001lv

bradgrafelman;11018449 wrote:
For one, this:
if ($numrows == 0);
is the same as this:
// do absolutely nothing
due to the semicolon after the if() statement.

Second, you still have the same problem I mentioned - all of your code is inside the if() statement that checks if there are ZERO results. So even if you get rid of the semicolon that doesn't belong, your code will execute none of your code after you execute the SQL query and store the number of rows inside $numrows.

ok found it and fixed i think is this right?

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

I get the first 8 results displayed correctly . This output shows me that there are more than 8 results

echo "<p><br />Showing results $b to $a of $numrows</p>";

When i click link to see the next 8 results the page is empty. I have been searching last two whole days everywhere on how to add pagination, use pagination any thing on pagination and can't figure it out.

Problem is in the links or the whole pagination part of script, i think.. at this point i am just guessing. Gonna go work at it some more. Any help to get on the right track welcomed.

darkangel2001lv

Update:

found error in links to old searchterm var. Changed that however now when I click to see the next 8 results next page displays the same results not the next 8. hmmmm...

Revised Script

<?php

  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot; <br />";   // display what the person searched for
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=8; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search term!</p>";
  exit;
  }

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// begin to show results set
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$title <br />" ;

  }

$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "<br /><a href=\"search.php?s=$prevs&SearchTerm=$var\">; 
  Prev 8</a>;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "<br /><a href=\"search.php?s=$news&SearchTerm=$var\">Next 8 ;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p><br />Showing results $b to $a of $numrows</p>";

?>

Derokorian

You don't set $s = $_GET['s'] anywhere, so it will always be empty in your if statement.

dalecosp

darkangel2001lv;11018457 wrote:
Update:

found error in links to old searchterm var.

Me, too 😉

Changed that however now when I click to see the next 8 results next page displays the same results not the next 8. hmmmm...

if (empty($s)) {

So, ask yourself ... will $s BE empty? Where is it coming from? I'll bet you can $_GET a clue from that 🙂

darkangel2001lv

thanks guys and dalecosp thanks made me laugh needed that. let me try and remember why that darn $s is even there......

Weedpacket

darkangel2001lv wrote:
Ok understand SQL injection, however this script is going on a internal server on a network with no web access so SQL injection is not an issue.

Very dangerous attitude to take, that.

dalecosp

Weedpacket;11018471 wrote:
Very dangerous attitude to take, that.

Hee hee, only somewhat related, but it reminds me of a story from the board here, where someone explained how they got their username ...

darkangel2001lv

dalecosp;11018461 wrote:
Me, too 😉
if (empty($s)) { 
So, ask yourself ... will $s BE empty? Where is it coming from? I'll bet you can $_GET a clue from that 🙂

Ok logic tells me that the $s should never be empty, due to it should be the string that came back from $query based on $_GET['SearchTerm'] am i correct? If this is the case found this while searching changed it to what my search var. something like this,

if(isset($_GET['SearchTerm']))
{
$s=$_GET['SearchTerm'];
}
$string = @$_GET['SearchTerm'] ;
$trimmed = trim($string);

if so where do i place it in current script? My thoughts are right at the top of script where

// Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot;";   // display what the person searched for

  $trimmed = trim($var); //trim whitespace from the stored variable

But if i do that then $var is not defined???? Am I on the right path ?

dalecosp

Is there any reason you can't eliminate/do away with one var name or the other?

And, if there isn't, what's to say you couldn't do something like:


if(isset($_GET['SearchTerm'])) 
{ 
$s=$var=$_GET['SearchTerm'];

I mean, apart from the fact it's kinda wasteful and perhaps indicates poor planning.... 🙂

darkangel2001lv

dalecosp;11018567 wrote:
Is there any reason you can't eliminate/do away with one var name or the other?

And, if there isn't, what's to say you couldn't do something like:
if(isset($_GET['SearchTerm'])) 
{ 
$s=$var=$_GET['SearchTerm']; 
I mean, apart from the fact it's kinda wasteful and perhaps indicates poor planning.... 🙂

I agree on the poor planning statement. I have tried to get rid of one of the variables like so, also replacing $var with $s and same results.

?php

  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot;";   // display what the person searched for
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=8; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  exit;
  }

// check for a search parameter
if (!isset( $trimmed))
  {
  echo "<p>We dont seem to have a search term!</p>";
  exit;
  }

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$trimmed%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0); 
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" .  $trimmed . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";

// next determine if s has been passed to script, if not use 0
  if (empty($trimmed)) {
  $trimmed=0;
  }

// get results
  $query .= " limit  $trimmed,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// begin to show results set
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$title <br />" ;

  }

$currPage = (($trimmed/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($trimmed>=1) { // bypass PREV link if s is 0
  $prevs=($trimmed-$limit);
  print "<br /><a href=\"search.php?s=$prevs&SearchTerm=$var\">; 
  Prev 8</a>";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($trimmed+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$trimmed+$limit;

  echo "<br /><a href=\"search.php?s=$news&SearchTerm=$trimmed\">View Next 8 Results;</a>";
  }

$a = $trimmed + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $trimmed + 1 ;
  echo "<p><br />Showing results $b to $a of $numrows</p>";
  }
?>

But in doing so get no results and

// get results
  $query .= " limit  $trimmed,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

gets tripped. Gonna try way you suggested to just try and get it working sort out from there will post the out come.

darkangel2001lv

Update :

Changing

  // Get the search variable from URL

  $var = $_GET['SearchTerm'] ;
  echo "<p>You searched for: &quot;" . $var . "&quot;";   // display what the person searched for
  $trimmed = trim($var); //trim whitespace from the stored variable

To:

  /// Get the search variable from URL
if(isset($_GET['SearchTerm'])) 
{ 
$s=$var=$_GET['SearchTerm'];   

}
  echo "This is the search query: ". $var; //just checking to see if search term is being passed

  $trimmed = trim($var); //trim whitespace from the stored variable 
// rows to return
$limit=8;

failed as well.

error tracking gives:
An error occurred in script '/home/content/84/8829884/html/test/search.php' on line 168:
 Undefined variable: var
 Date/Time: 11-21-2012 16:23:56
 <pre>Array
(
[GLOBALS] => Array
RECURSION
[_POST] => Array
(
)

[_GET] => Array
    (
    )

[_COOKIE] => Array
    (
        [__utma] => 107246494.1449818940.1353537901.1353537901.1353537901.1
        [__utmb] => 107246494.14.10.1353537901
        [__utmc] => 107246494
        [__utmz] => 107246494.1353537901.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
        [_pk_id_1_caea] => fbb76027881649de.1353537903.1.1353540225.1353537903.
        [_pk_ses_1_caea] => *
    )

[_FILES] => Array
    (
    )

[live] => 1
[email] => admin.webmaster@midstatebakerydist.com

)
</pre>

Weedpacket

darkangel2001v wrote:
Undefined variable: var

that will happen if [font=monospace]$var[/font] is not defined. It is only defined here:

$s=$var=$_GET['SearchTerm'];

And that line will only run if [font=monospace]isset($_GET['SearchTerm'])[/font] is true, i.e., if the [font=monospace]$GET[/font] array has an element named [font=monospace]'SearchTerm'[/font]. Looking at

[_GET] => Array
(
)

We see that it does not.

From some code posted earlier:

// check for a search parameter
if (!isset( $trimmed))

[font=monospace]$trimmed[/font] is always set, because a dozen lines earlier you have

  $trimmed = trim($var); //trim whitespace from the stored variable

What's more, in between you check

if ($trimmed == "")

So you're assuming that [font=monospace]$trimmed[/font] is set at this point.

Here's an idea. Try checking that [font=monospace]$_GET['SearchTerm'][/font] exists before you try to use it, and have some idea of what to do if it doesn't without ignoring the fact.

darkangel2001lv

Update: I have been working hard on this rewrote script to try and clear it up:

Full Reworked Script. Please Disregard Previous scripts. Have Discarded them.

Current Scripts

Form ( search.php)

<form name="form" action="results.php" method="GET">
div align="center">
<p>
<input name="SearchTerm" type="text" value="Enter Your Search Term........." size="50" />
<input type="hidden" name="submitted" value="TRUE" />
<input type="submit" name="submit" value="Search" />
<br>
Quick Link: View Whole Grain products, click <a href="wg-products.php">here</a></p>
</div>
form>

And Processing script (process.php)

<?php
  // check for a search parameter
  // Get the search variable from URL

  if (isset($_GET['SearchTerms'])); {

   $SearchTerms = trim($_GET['SearchTerms']);
   $SearchTerms = strip_tags($SearchTerms); // removes any html/javascript.
   }
  if (strlen($SearchTerms) < 2 and !in_array($SearchTerms)) {
  }else{
	   echo "Search terms must be longer than 2 characters. If you need help please <a href='../help/search-help.php'>click here.</a>"; // Checks search term is longer than 2 characters.

  $SearchTermDB = mysql_real_escape_string($SearchTerms); // prevents SQL Injection

  }


// rows to return
$limit=8;  

// Connect to the database.
require_once ('includes/connections/mysql_nfacts.php'); 

// Build SQL Query  

$query = "SELECT link, keywords FROM products WHERE keywords like \"%$SearchTermDB%\"  

  order by keywords"; 

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "Sorry, your search: &quot;" . $SearchTermDB . "&quot; returned zero results. Please try again. If you need help please <a href='../help/search-help.php'>click here.</a><p>";
  }

// get results
  $query .= " limit $SearchTermDB,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// begin to show results set
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["link"];

  echo "$title <br />" ;

  }

$currPage = (($SearchTermDB/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($SearchTermDB>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "<br /><a href=\"results.php?s=$prevs&SearchTerm=$SearchTermDB\">; 
  Prev 8</a>;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($SearchTermDB+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$SearchTermDB+$limit;

  echo "<br /><a href=\"results.php?s=$news&SearchTerm=$SearchTermDB\">Next 8 ;</a>";
  }

$a = $SearchTermDB + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $SearchTermDB + 1 ;
  echo "<p><br />Showing results $b to $a of $numrows</p>";

?>

Errors that have been found:

Error 1 9 this one confuses me Due to $SearchTermsDB is defined (see reworked script line 20)

An error occurred in script '/home/content/84/8829884/html/test/results.php' on line 171:
 Undefined variable: SearchTermDB
 Date/Time: 11-23-2012 10:15:15
 <pre>Array
(
[GLOBALS] => Array
RECURSION
[_POST] => Array
(
)

[_GET] => Array
    (
        [SearchTerm] => rolls
        [submitted] => TRUE
        [submit] => Search
    )

[_COOKIE] => Array
    (
        [__utma] => 107246494.1524893141.1353092377.1353682934.1353690084.13
        [__utmz] => 107246494.1353095668.2.2.utmcsr=*********.com|utmccn=(referral)|utmcmd=referral|utmcct=/
        [_pk_id_1_67e2] => 22a9ccccd5c8c264.1353340941.6.1353690922.1353685352.
        [__utmc] => 107246494
        [__utmb] => 107246494.9.10.1353690084
        [_pk_ses_1_67e2] => *
    )

[_FILES] => Array
    (
    )

[live] => 1
[email] => **************.com
[SearchTerms] => 
[limit] => 8

Error 2

An error occurred in script '/home/content/84/8829884/html/test/results.php' on line 158:
 Wrong parameter count for in_array()
 Date/Time: 11-23-2012 10:15:15
 <pre>Array
(
[GLOBALS] => Array
RECURSION
[_POST] => Array
(
)

[_GET] => Array
    (
        [SearchTerm] => rolls
        [submitted] => TRUE
        [submit] => Search
    )

[_COOKIE] => Array
    (
        [__utma] => 107246494.1524893141.1353092377.1353682934.1353690084.13
        [__utmz] => 107246494.1353095668.2.2.utmcsr=*********.com|utmccn=(referral)|utmcmd=referral|utmcct=/
        [_pk_id_1_67e2] => 22a9ccccd5c8c264.1353340941.6.1353690922.1353685352.
        [__utmc] => 107246494
        [__utmb] => 107246494.9.10.1353690084
        [_pk_ses_1_67e2] => *
    )

[_FILES] => Array


    (
    )

[live] => 1

Error 3

An error occurred in script '/home/content/84/8829884/html/test/results.php' on line 155:
 Undefined index: SearchTerms
 Date/Time: 11-23-2012 10:15:15
 <pre>Array
(
[GLOBALS] => Array
RECURSION
[_POST] => Array
(
)

[_GET] => Array
    (
        [SearchTerm] => rolls
        [submitted] => TRUE
        [submit] => Search
    )

[_COOKIE] => Array
    (
        [__utma] => 107246494.1524893141.1353092377.1353682934.1353690084.13
        [__utmz] => 107246494.1353095668.2.2.utmcsr=************.com|utmccn=(referral)|utmcmd=referral|utmcct=/
        [_pk_id_1_67e2] => 22a9ccccd5c8c264.1353340941.6.1353690922.1353685352.
        [__utmc] => 107246494
        [__utmb] => 107246494.9.10.1353690084
        [_pk_ses_1_67e2] => *
    )

[_FILES] => Array
    (
    )

[live] => 1

result page just displays error message that is set in my error handling file. That part is working luckily. Why is it so difficult to just add pagination to a search script? Two weeks now i have been trying to do this....... ugh. thanks everyone that has helped. Just am not getting what you are saying i guess. There has to be an easier way to do this.