when i filter a search it shows 1st page but cannot show contents on 2nd page.
i have the following code:
<? include_once "connect.php";
if(trim($_REQUEST['searchkeyword'])!="")
{
$searchkeyword=$_REQUEST['searchkeyword'];
$searchkeyword1=str_replace(".", "", $searchkeyword);
}
if($_REQUEST['stype']!="" && $_REQUEST['start']=="" && trim($_REQUEST['searchkeyword'])!="")
{
$qry="INSERT INTO search_history set search_type='".$_REQUEST['stype']."', search_text='".$_REQUEST['searchkeyword']."', search_date=now(), result_url='course_listing.php?searchkeyword=".$_REQUEST['searchkeyword']."'";
mysql_query($qry);
$_GET['stype']="";
}
$PVR_SectionID="2";
$extQry="";
$extQry2="";
if(isset($_REQUEST['searchkeyword']))
{
$extQry.=" and (department like '%".$_REQUEST['searchkeyword']."%' or course_title like '%".$searchkeyword1."%' or course_title like '%".$_REQUEST['searchkeyword']."%'
or course_desc like '%".$_REQUEST['searchkeyword']."%')";
$extQry2=" and (name like '%".$_REQUEST['searchkeyword']."%' or contact_name like '%".$_REQUEST['searchkeyword']."%' or country like '%".$_REQUEST['searchkeyword']."%' or city like '%".$_REQUEST['searchkeyword']."%' or description like '%".$_REQUEST['searchkeyword']."%')";
}
if(isset($_REQUEST['subject']))
{
$extQry.=" and sub_id in (";
$cnt=0;
foreach($_REQUEST['subject'] as $k=>$v)
{
$cnt++;
if($cnt>1) { $extQry.=",".$v; }
else { $extQry.=$v; }
}
$extQry.=") ";
}
if(isset($_REQUEST['region']))
{
$extQry.=" and uni_id in (SELECT id from institution where is_active='1' and reg_id in(";
$extQry2.=" and reg_id in(";
$cnt=0;
foreach($_REQUEST['region'] as $k=>$v)
{
$cnt++;
if($cnt>1) { $extQry.=",".$v; $extQry2.=",".$v; }
else { $extQry.=$v; $extQry2.=$v; }
}
$extQry.=") ) ";
$extQry2.=")";
}
if(isset($_REQUEST['studymode']))
{
$extQry.=" and id in ( SELECT course_id from course_qdm where mode in (";
$cnt=0;
foreach($_REQUEST['studymode'] as $k=>$v)
{
$cnt++;
if($cnt>1) { $extQry.=",'".$v."'"; }
else { $extQry.="'".$v."'"; }
}
$extQry.=") ) ";
}
if(isset($_REQUEST['institution']))
{
$extQry.=" and uni_id='".$_REQUEST['institution']."'";
}
$courseQry="SELECT * FROM course where is_active='1' $extQry ";
$crsRes=mysql_query($courseQry);
$totCourse=mysql_affected_rows();
$pgLimit=10;
$shFrom=intval($_REQUEST['start'])+1;
$shTo= $shFrom + $pgLimit - 1;
if($shTo>$totCourse) $shTo=$totCourse;
$CRSresult=$prs_pageing->number_pageing22($courseQry,$pgLimit,10,'N','Y');
$courseQry="SELECT * FROM institution where is_active='1' $extQry2";
$instRes=mysql_query($courseQry);
$totInstitution=mysql_affected_rows();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<? getMeta("4") ;?>
<?php include("head_script.php"); ?>
<script src="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/Scripts/cforms.js" type="text/javascript"></script>
<script src="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/SpryAssets/SpryAccordion.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<link href="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/SpryAssets/SpryAccordion.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><? include_once "header.php"; ?></td>
</tr>
<tr>
<td><table width="950" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="753" height="32"><div id="track_2"><a href="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/index.php" style="padding-left:0px;"><img src="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/images/btn_home.gif" /></a><a href="../../../../DOCUME~1/Farhan/LOCALS~1/Temp/course_search.php">Find courses and research</a><span>Search Results</span></div></td>
<td width="10" rowspan="2"> </td>
<td width="187" rowspan="2" align="center" valign="top" bgcolor="#f9f9f9"><? include_once "banners_block.php"; ?></td>
</tr>
<tr>
<td valign="top" id="contents">
<h1>you have <?=$totCourse;?> Course Search Result</h1>
<? include "course_filter.php"; ?>
<? if($CRSresult[1]!="")
{
?>
<div>
<h2>Showing <?=$shFrom;?>-<?=$shTo;?></h2></div>
<?
while($CRSrow=mysql_fetch_array($CRSresult[0]))
{
?>
<div class="mix">
<a href="<?=course_details_URL($CRSrow['id']);?>"><b><?=stripslashes($CRSrow['course_title']);?></b></a>
<? $quaRes=mysql_query("SELECT qualification from course_qdm where course_id='".$CRSrow['id']."'");
if(mysql_affected_rows()>0)
{ $cnt=0;
$qArr=array();
while($quaRow=mysql_fetch_array($quaRes))
{
if(!array_key_exists($quaRow['qualification'],$qArr))
{
$cnt++;
if($cnt>1) { echo " / ".stripslashes($quaRow['qualification']); }
else { echo stripslashes($quaRow['qualification']); }
$qArr[$quaRow['qualification']]=1;
}
}
}
?>
<a href="<?=university_prof_details_URL($CRSrow['uni_id']);?>" ><strong><?=stripslashes(GetValue("institution","name","id",$CRSrow['uni_id']));?></strong></a>
- <?=stripslashes($CRSrow['department']);?>
<br />
<span><?=substr(strip_tags(stripslashes($CRSrow['course_desc'])),0,100);?>...</span> <a href="<?=course_details_URL($CRSrow['id']);?>"><strong>read more</strong></a>
</div>
<? } ?>
<?php $sub_get = $_GET['subject'];
$s_pass = $sub_get[0];
?>
<?php /*?><div class="link_large"><a href="all_course.php?q=<?=base64_encode($extQry);?>">More Courses</a></div><?php */?>
<? } ?>
<div>
<?=$CRSresult[1];?>
</div>
</td>
</tr>
</table></td>
</tr>
<tr>
<td><? include_once "bookmark.php"; ?></td>
</tr>
<tr>
<td><? include_once "footer.php"; ?></td>
</tr>
</table>
</body>
</html>