hai friends,i am having doubt in pagination concept.if i am retriving records form the database with out if condition means it is working but when i using query inside if condition i am getting only 1st page record , 2nd page record not coming.i am getting the output"Sorry, There is no result corresponding to your query" but i am having records in database.then and i tried with session but i didnt get not even 1st page.please help me its very urgent tell any idea friends.
<?php
include "dbcon.php";
@extract($POST);
$rowsPerPage =1;
$pageNum = 1;
if(isset($GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
//condition
if($cbUnit==buy && $txtToBudjet=="selected" && $no_child!="Other" && $txtFromBudjet<="70000000")
{
$cbUnit=sell;
//query inside condition
$row=mysql_query("select * from furtherselldetails join selldetails on selldetails.transactiontype='$cbUnit' AND selldetails.rateto between 0 and '$txtFromBudjet' && selldetails.propertyid=furtherselldetails.propertyid" ." LIMIT $offset, $rowsPerPage") or die (mysql_error());
$row1=mysql_query("select COUNT(*) AS numrows from furtherselldetails join selldetails on selldetails.transactiontype='$cbUnit' AND selldetails.rateto between 0 and '$txtFromBudjet' && selldetails.propertyid=furtherselldetails.propertyid") or die (mysql_error());
}
if($num==0)
{
?>
<table align="center" border="5" width="50%" height="20%" bordercolor="blue"><tr><td align="center">
<?php echo "Sorry, There is no result corresponding to your query";?></td></tr></table>
<?php
}
$query1 = mysql_fetch_array($row1, MYSQL_ASSOC) or die(mysql_error());
$numrows = $query1['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{ if ($page == $pageNum)
{ $nav .= " $page ";
}
else
{ $nav .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
if ($pageNum > 1){
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">Prev</a> ";
$first = " <a href=\"$self?page=1\">First Page</a> ";
}
else
{
$prev = ' ';
$first = ' ';
}if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
echo "<br/>";
$next = " <a href=\"$self?page=$page\">Next</a> ";
$last = " <a href=\"$self?page=$maxPage\">Last Page</a> ";
}
else
{
$next = ' ';
$last = ' ';
}
echo $first . $prev . $nav . $next . $last;
mysql_close();
?>
help me friends thanks
