51
HI All
I have a search page' s result which view 3results/per page,but my "next" link to view next page is not working.
Here is my code :
[PHP]<?php
// Get the search variable from URL
$string = @$_GET['q'] ;
$trimmed = trim($string); //trim whitespace from the stored variable
// rows to return
$limit=3;
// check for an empty string and display a message.
if ($trimmed == "")
{
echo "";
exit;
}
// check for a search parameter
if (!isset($string ))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
//connect to your database
mysql_connect(" localhost","pur pasia_CMS","CMS "); //(host, username, password)
//specify database
mysql_select_db ("purpasia_VFM" ) or die("Unable to select database"); //select which database we're using
// Build SQL Query
$query = "select * from en_c1 where t1 like \"%$trimmed% \"
order by t1"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mys ql_query($query );
$numrows=mysql_ num_rows($numre sults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
echo "<h4>Result s</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>";
}else
// 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($qu ery) 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 "Results";
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_arr ay($result)) {
$title = $row["t1"];
echo "$count.) $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 " <a href=\"$PHP_SEL F?s=$prevs&q=$s tring\"><< ;
Prev</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%$limi t) {
// 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_SEL F?s=$news&q=$st ring\">Next> ></a>";
}
$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "<p>Showing results $a of $numrows</p>";
?>[/PHP]
Any idea why is this problem?
Here is the output : http://www.purpleasia.com/clients/VF....php?s=1&q=vfm
thanks so much
