search engine for a MySQL databse using php

[huntrguy102]

I have created a php Mysql database search engine. which is awesome, except for the fact that it wont go to my next 10 results. It pulls the first 10 results fine. it connects to my database which is in the code but I wont show it to you for obvious reasons, so here is the code after the mysql connect.

 

// Build SQL Query 

$query = "SELECT * FROM books WHERE title LIKE \"%$trimmed%\" 

  order by title";

$query2 = "SELECT * FROM books WHERE author LIKE \"%$trimmed%\" 

  order by author"; // EDIT HERE and specify your table and field names for the SQL query

 

$numresults=mysql_query($query);

$numrows=mysql_num_rows($numresults);

  $numresults2=mysql_query($query2);

$numrows2=mysql_num_rows($numresults2);

 

// If we have no results, offer a google search as an alternative

 

if ($numrows == 0)

  {

  echo "<h4>Results</h4>";

  echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>";

 

// google

echo "<p><a href=\"http://www.google.com/search?q="

  . $trimmed . "\" target=\"_blank\" title=\"Look up

  " . $trimmed . " on Google\">Click here</a> to try the

  search on google</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");

  $query2 .= " limit $s,$limit";

  $result2 = mysql_query($query2) or die("Couldn't execute query");

 

// display what the person searched for

echo "<p>You searched for: "" . $var . ""</p>";

 

// begin to show results set

echo $title;

echo $author;

$count = 1 + $s ;

 

// now you can display the results returned

 

 

  while ($row= mysql_fetch_array($result)) {

  $title = $row["title"];

    $author = $row["author"];

  echo $count++;

 

  echo ".) $title - " ;

  echo "$author<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 " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><<

  Prev 10</a>&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 " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >&gt</a>";

  }

 

$a = $s + ($limit) ;

  if ($a > $numrows) { $a = $numrows ; }

  $b = $s + 1 ;

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

 

?>

 

Any help in figuring out what is wrong would be greatly appreciated.

 

[sader]

SELECT * FROM books WHERE title LIKE \"%$trimmed%\" 

  order by title LIMIT 20, 10

 

Should return 10 results starting from 20

[sader]

maybe register_globals = Off ?

if so try put $s = $_GET['s'];

 

before

$query = "SELECT * FROM books WHERE title LIKE \"%$trimmed%\" 

  order by title";

[huntrguy102]

I dont know if this would've helped but here is the code above the mysql connect

 

<?php

 

  // Get the search variable from URL

 

  $var = @$_GET['q'] ;

  $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 == "")

  {

  echo "<p>Please enter a search...</p>";

  exit;

  }

 

// check for a search parameter

if (!isset($var))

  {

  echo "<p>We dont seem to have a search parameter!</p>";

  exit;

  }

[huntrguy102]

the specific line that I think may be causing the problem is this line:

 

  $news=$s+$limit;

 

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

  }

 

 

 

but I'm not quite sure.

[huntrguy102]

Well nevermind thank you very much sader. the $s = $_GET['s'] made it work.