Hi,
I am sending my code ,my query is running right but in the pagging the content(data) of last page are display on first page so when ever next button is clicked no data are displaying
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<?php
//print_r($_REQUE ST);
$chanid = 1;
include "dbconnect.php" ;
$page = $_REQUEST["page"];
//if(isset($_POST['submit']))
//{
//echo $text=$_POST['namecontains'];
//$text1=$_POST['meaningcontain s'];
//}
?>
<head>
<title>Your baby name search results - YeahBaby.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="descripti on" content="Your baby name search results - YeahBaby.com" />
<meta name="keywords" content="Your baby name search results - YeahBaby.com" />
<meta name="author" content="Jay Nelson" />
<link rel="stylesheet " type="text/css" href="http://www.yeahbaby.co m/baby-includes/styles.css" />
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-546870-2";
urchinTracker() ;
</script>
<!---<script language="javas cript">
document.form1. action="baby-names-results.php?rec sno="+$check1
document.form1. submit();
</script>--->
<link href="css/tables.css" rel="stylesheet " type="text/css" />
<style type="text/css">
<!--
.text_heading { font-size: 11px; font-weight: bold; color: #000000;
}
-->
</style>
</head>
<body>
<?php include "z-728x90.php" ?>
<div id="container-entire-page">
<div id="container-crumb-path">
<div id="crumb-path">
<a href="http://www.yeahbaby.co m" title="baby names">YeahBaby .com</a> >
<a href="http://www.yeahbaby.co m/baby-names-search.php" title="baby names search">Advance d Names Search</a> >
Search Results
</div>
</div>
<?php include "z-header001-begin.php" ?>Your baby name search results - YeahBaby.com
<?php
include "z-header001-end.php" ?>
<div id="container-main-page-content">
<div id="container-two-left-columns">
<div id="container-center-column">
<h2><b>Your Search Results</b></h2>
<h3>Below are a list of baby names meeting your search criteria. Click any of the names for a ton of baby names info!</h3>
<p>
<!-- Start display results -->
<table border="0" cellpadding="0" cellspacing="0" id="table-outer">
<tr>
<td> </td>
<td>
<tr>
<td><img src="baby-includes/cleardot.gif" height=1 width=40></td>
<td>
<?php
//print_r($baby);
// if(isset($_POST['submit']))
// {
$universe=$_REQ UEST["universe"];
$namecontains = $_REQUEST["namecontai ns"];
$namecontains = strip_tags($nam econtains);
$meaningcontain s = $_REQUEST["meaningcontain s"];
$meaningcontain s = strip_tags($mea ningcontains);
$genderis = $_REQUEST["genderis"];
$gender = $_REQUEST["genderis"];
$genderis = strip_tags($gen deris);
$displaypage = $_REQUEST["displaypag e"];
$namebeginsexpr ession = $_REQUEST["namebeginsexpr ession"];
$ethnicity=$_RE QUEST['checkbox'];
$ethnicityexpre ssion = $_REQUEST["ethnicityexpre ssion"];
$syllablesstrin g = $_REQUEST["syllablesstrin g"];
$syllable = $_REQUEST["syllablesstrin g"];
$minletters = $_REQUEST["minletters "];
$maxletters = $_REQUEST["maxletters "];
$namelength = $_REQUEST["namelength "];
$topbabynames = $_REQUEST["topbabynam es"];
$numberofsyllab les=$_REQUEST["numberofsyllab les"];
$check1=$_REQUE ST['bab'];
$check2=$_REQUE ST['cp'];
$baby=$_REQUEST['recsno'];
$baby1=$_REQUES T['endno'];
$data=trim($bab y);
$ex=explode(" ",$data);
$size1=sizeof($ ex);
$data1=trim($ba by1);
$checkend=explo de(" ",$data1);
$size=sizeof($c heckend);
//}
// print_r($checke nd);
//echo $sql="DELETE FROM person_records WHERE User_id='$check b";
//$result=mysql_q uery($sql) or die(mysql_error ());
//print_r ($check1);
$namebegins=$_R EQUEST['namebegins'];
// }
if ($displaypage != 0 ) {
// need to replace stars with apostrophes so is passed properly from hidden form
$namebeginsexpr ession = ereg_replace(": ", "'", $namebeginsexpr ession);
$nameendsexpres sion = ereg_replace(": ", "'", $nameendsexpres sion);
$ethnicityexpre ssion = ereg_replace(": ", "'", $ethnicityexpre ssion);
$query = ereg_replace(": ", "'", $query);
// need to replace stars with apostrophes so is passed properly from hidden form
}
//echo $displaypage."R avi--";
/*if ($displaypage == 0 ) {
$index = 0;
$syllablesstrin g = "";//'(';
while ($index < 5) {
$numberofsyllab les[$index] = strip_tags($num berofsyllables[$index]);
if ($numberofsylla bles[$index] != '') {
$syllablesstrin g = $syllablesstrin g . $numberofsyllab les[$index];
// else $syllablesstrin g = $syllablesstrin g .', '. $numberofsyllab les[$index] ;
}
$index++;
}
*/
if (strlen($syllab lesstring) > 3) {
$syllablesstrin g = substr($syllabl esstring, 0, -2);
}
//$syllablesstrin g = $syllablesstrin g . ')';
//if ($syllablesstri ng == '()') {
if ($syllablesstri ng == '') {
$syllablesstrin g = '1, 2, 3, 4, 5, 6, 7, 8';
// $syllablesstrin g=$_REQUEST['syllablesstrin g'];
}
$index = 0;
$namebeginsexpr ession = '(';
$nameendsexpres sion = '(';
while ($index < 26) {
if ($namebegins[$index] != '') {
$namebeginsexpr ession = $namebeginsexpr ession . " `babyname` LIKE '$namebegins[$index]%' OR ";
}
if ($nameends[$index] != '') {
$nameendsexpres sion = $nameendsexpres sion . " `babyname` LIKE '%$nameends[$index]' OR ";
}
$index++;
}
if ($namebeginsexp ression != '(') {
$namebeginsexpr ession = substr($namebeg insexpression, 0, -3);
$namebeginsexpr ession = $namebeginsexpr ession . ')';
}
else {
$namebeginsexpr ession = " `babyname` LIKE '%'";
}
if ($nameendsexpre ssion != '(') {
$nameendsexpres sion = substr($nameend sexpression, 0, -3);
$nameendsexpres sion = $nameendsexpres sion . ')';
}
else {
$nameendsexpres sion = " `babyname` LIKE '%'";
}
$index = 0;
$ethnicityexpre ssion = '(';
while ($index < 30) { // 30 is the number of different origin categories, change this if need be
if ($ethnicity[$index] != '') {
$ethnicityexpre ssion = $ethnicityexpre ssion . " `origin` LIKE '$ethnicity[$index]%' OR ";
}
$index++;
}
if ($ethnicityexpr ession != '(') {
$ethnicityexpre ssion = substr($ethnici tyexpression, 0, -3);
$ethnicityexpre ssion = $ethnicityexpre ssion . ')';
}
else {
$ethnicityexpre ssion = " `origin` LIKE '%'";
}
//}
if ($minletters > $maxletters) {
$i = $maxletters;
$maxletters = $minletters;
$minletters = $i;
}
if(!isset($_GET['pageno']) || $_GET['pageno']==0)
{
$pageno=1;
}
else
$pageno=$_GET['pageno'];
$currentpage=$p ageno - 1;
$pagesize=50;
$rownum = $currentpage*$p agesize;
?>
<?php
//temporaray
//$universe = "all";
//$displaypage = 0;
//
if (isset($_GET['syllablesstrin g']))
$syllablesstrin g=$_GET['syllablesstrin g'];
if ($universe == "all") {
if ($displaypage == 0) {
//print_r($checkb );
print_r($checkb 1);
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2=="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
//$query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
//$query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpr ession . ' AND ' . $nameendsexpres sion . " AND `babyname` LIKE '%$namecontains %' AND `meaning` LIKE '%$meaningconta ins%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstrin g AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
//}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$check b1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
}
}}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check2!=""&&$c heck1=="" && $namecontains== "")
{
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
echo $babyresult=mys ql_fetch_array( $query1);
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !="") {
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
//}
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namec ontains%$checkb 1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1=="" && $check2=="" &&$namecontains !="")
{
$query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '$namecontains% 'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
// $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$namecontains %' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
//}
else
{
//}
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
if ($universe == "top")
{
if ($displaypage == 0) {
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2=="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
//$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}
}
// echo $query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpr ession . ' AND ' . $nameendsexpres sion . " AND `babyname` LIKE '%$namecontains %' AND `meaning` LIKE '%$meaningconta ins%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstrin g AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
$query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$check b1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check2!=""&&$c heck1=="" && $namecontains== "")
{
for($j=0;$j<$si ze1;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namec ontains%$checkb 1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !=""){
$query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$namecontains %' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
else
{
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
//}
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
///-------- 20-------------------------------------------------------------------------
if(isset($pages ize) && $pagesize!="")
{
$data2 =$query." LIMIT $rownum, $pagesize";
$product_query1 = mysql_query($da ta2);
}//----------------------------------------//////////////---------------------------------------------------------------
$total=mysql_nu m_rows($query1) ;
//echo $pagesize;
$movepage=floor ($total/$pagesize);
$move=$total%$p agesize;
if($move !=0)
$movepage=$move page+1;
if($movepage <1)
{ $movepage = 1; }
//---------------------------------------------------------------------------------
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$row1=mysql_num _rows($product_ query1);
?>
<body>
<tr>
<td><strong>Pag e <?=$pageno?> of your search results.</strong></td>
</tr>
<tr><td>Page <?=$pageno?> of <?=$movepage? > pages.</td>
</tr>
<tr><td><tr>
<td><span class="text_hea ding" style="padding-right:20px">
<?php if ($pageno>1)
{?>
< <!--<a href="baby-names-results.php?pag eno=<?//=$pageno-1?>&genderi s=<?//=$gender?>& ethnicity=<?//=$ethnicity?>&a mp;syllablesstr ing=<?//=$syllablesstri ng?>&minlet ters=<?//=$minletters?>& amp;maxletters= <?//=$maxletters?>& amp;meaningcont ains=<?//=$meaningcontai ns?>&checkb ox=<?//=$_REQUEST['checkbox']?>&namecont ains=<?//=$namecontains? >&displaypa ge=<?//=$_REQUEST["displaypag e"]?>&universe =<?//=//$_REQUEST["universe"]?>&bab=<?//=$_REQUEST['recsno'];?>&cp=<?//=$_REQUEST['endno']?>&namebegi ns=<?//=$_REQUEST['namebegins']?>" class="link">Pr evious</a>--->
<a href="baby-names-results.php?pag eno=<?=$pageno-1?>&genderis=<? =$gender?>ðn icity=<?=$ethni city?>&syllable sstring=<?=$syl lablesstring?>& minletters=<?=$ minletters?>&ma xletters=<?=$ma xletters?>&mean ingcontains=<?= $meaningcontain s?>&//checkbox=<?=$_R EQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>"&namebegins =<?=$_REQUEST['namebegins']?>" class="link">Pr evious</a>
<? } ?>
<?php
$end=20;
if ($pageno>20) $start=($pageno-20)+1;
if ($movepage<20) $end=$movepage;
if ($movepage>20 && $pageno>20) $end=$pageno;
// $start
for($pg=$start; $pg<=$end;$pg++ )
{
if($pg==$pageno ) echo "<strong>".$pg. "</strong> ";
else {?>
<a class="link" href="baby-names-results.php?pag eno=<?php echo $pg; ?>ðnicity=<? =$ethnicity?>&g enderis=<?=$gen der?>&syllables string=<?=$syll ablesstring?>&m inletters=<?=$m inletters?>&max letters=<?=$max letters?>&meani ngcontains=<?=$ meaningcontains ?>&checkbox=<?= $_REQUEST['checkbox']?>&namecontains =<?=$namecontai ns?>&displaypag e=<?=$_REQUEST["displaypag e"]?>&universe=<?= $_REQUEST["universe"]?>&bab=<?=$_REQ UEST['bab'];?>&cp=<?=$_REQ UEST['cp']?>&baby=<?=$_RE QUEST['recsno'];?>&baby1=<?=$_ REQUEST['endno'];?>&namebegins= <?=$_REQUEST['namebegins']?>"><strong><?p hp echo $pg; ?></strong></a>
<?php
} }
?>
<?php if ($pageno<$movep age)
{ ?>
<a href="baby-names-results.php?pag eno=<?=$pageno+ 1?>&ethnici ty=<?=$ethnicit y?>&genderi s=<?=$gender?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Ne xt</a>>
<? } ?>
</span></td>
</tr>
<?php
if($row1>0)
{
while($babyresu lt=mysql_fetch_ array($product_ query1))
{
?>
<tr>
<td id="td-col"> </tr>
<tr><td>
<table width="391" border="0" cellspacing="1" cellpadding="1" id="table-inner">
<tr>
<td id="td-col"> </tr>
<tr>
<!---<td rowspan="2"><im g src="/pet-includes/pet-names-u.gif"></td>--->
<td id="td-col"><a href='http://www.yeahbaby.co m/baby-name.php?name=< ?=$babyname?>'> <strong><?=$bab yname ?></strong></a> </tr>
<tr>
<td><? $babyname = $babyresult['babyname'];?></td>
</tr>
<tr>
<td><? $thebabyname = ucfirst(strtolo wer($thebabynam e));?></td>
</tr>
<tr>
<td><? $gender=$babyre sult1['gender'];?></td>
</tr>
</table></td></tr>
<?
/*echo $babyname = $babyresult['babyname'];
$thebabyname = $babyresult['thebabyname'];
$thebabyname = ucfirst(strtolo wer($thebabynam e));
$namelength = $babyresult['babynamlen'];
*/
$displaypage++;
}}?>
<tr>
<td><span class="text_hea ding" style="padding-right:20px">
<?php if ($pageno>1){?>
< <a href="baby-names-results.php?pag eno=<?=$pageno-1?>&genderi s=<?=$gender?>& amp;ethnicity=< ?=$ethnicity?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Pr evious</a>
<? } ?>
<?php
$end=20;
if ($pageno>20) $start=($pageno-20)+1;
if ($movepage<20) $end=$movepage;
if ($movepage>20 && $pageno>20) $end=$pageno;
// $start
for($pg=$start; $pg<=$end;$pg++ )
{
if($pg==$pageno ) echo "<strong>".$pg. "</strong> ";
else {?>
<a class="link" href="baby-names-results.php?pag eno=<?php echo $pg; ?>ðnicity=<? =$ethnicity?>&g enderis=<?=$gen der?>&syllables string=<?=$syll ablesstring?>&m inletters=<?=$m inletters?>&max letters=<?=$max letters?>&meani ngcontains=<?=$ meaningcontains ?>&namecontains =<?=$namecontai ns?>&displaypag e=<?=$_REQUEST["displaypag e"]?>&universe=<?= $_REQUEST["universe"]?>&bab=<?=$_REQ UEST['bab'];?>&cp=<?=$_REQ UEST['cp']?>&baby=<?=$_RE QUEST['recsno'];?>&baby1=<?=$_ REQUEST['endno'];?>&namebegins= <?=$_REQUEST['namebegins']?>"><strong><?p hp echo $pg; ?></strong></a>
<?php
} }
?>
<?php if ($pageno<$movep age){ ?>
<a href="baby-names-results.php?pag eno=<?=$pageno+ 1?>&ethnici ty=<?=$ethnicit y?>&genderi s=<?=$gender?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Ne xt</a>>
<? } ?>
</span></td>
</tr><?
these are codes ,so please solve my problem why the content(data)of last page show on first page
thanks
Chitta Ranjan
Software Engineer
I am sending my code ,my query is running right but in the pagging the content(data) of last page are display on first page so when ever next button is clicked no data are displaying
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<?php
//print_r($_REQUE ST);
$chanid = 1;
include "dbconnect.php" ;
$page = $_REQUEST["page"];
//if(isset($_POST['submit']))
//{
//echo $text=$_POST['namecontains'];
//$text1=$_POST['meaningcontain s'];
//}
?>
<head>
<title>Your baby name search results - YeahBaby.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="descripti on" content="Your baby name search results - YeahBaby.com" />
<meta name="keywords" content="Your baby name search results - YeahBaby.com" />
<meta name="author" content="Jay Nelson" />
<link rel="stylesheet " type="text/css" href="http://www.yeahbaby.co m/baby-includes/styles.css" />
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-546870-2";
urchinTracker() ;
</script>
<!---<script language="javas cript">
document.form1. action="baby-names-results.php?rec sno="+$check1
document.form1. submit();
</script>--->
<link href="css/tables.css" rel="stylesheet " type="text/css" />
<style type="text/css">
<!--
.text_heading { font-size: 11px; font-weight: bold; color: #000000;
}
-->
</style>
</head>
<body>
<?php include "z-728x90.php" ?>
<div id="container-entire-page">
<div id="container-crumb-path">
<div id="crumb-path">
<a href="http://www.yeahbaby.co m" title="baby names">YeahBaby .com</a> >
<a href="http://www.yeahbaby.co m/baby-names-search.php" title="baby names search">Advance d Names Search</a> >
Search Results
</div>
</div>
<?php include "z-header001-begin.php" ?>Your baby name search results - YeahBaby.com
<?php
include "z-header001-end.php" ?>
<div id="container-main-page-content">
<div id="container-two-left-columns">
<div id="container-center-column">
<h2><b>Your Search Results</b></h2>
<h3>Below are a list of baby names meeting your search criteria. Click any of the names for a ton of baby names info!</h3>
<p>
<!-- Start display results -->
<table border="0" cellpadding="0" cellspacing="0" id="table-outer">
<tr>
<td> </td>
<td>
<tr>
<td><img src="baby-includes/cleardot.gif" height=1 width=40></td>
<td>
<?php
//print_r($baby);
// if(isset($_POST['submit']))
// {
$universe=$_REQ UEST["universe"];
$namecontains = $_REQUEST["namecontai ns"];
$namecontains = strip_tags($nam econtains);
$meaningcontain s = $_REQUEST["meaningcontain s"];
$meaningcontain s = strip_tags($mea ningcontains);
$genderis = $_REQUEST["genderis"];
$gender = $_REQUEST["genderis"];
$genderis = strip_tags($gen deris);
$displaypage = $_REQUEST["displaypag e"];
$namebeginsexpr ession = $_REQUEST["namebeginsexpr ession"];
$ethnicity=$_RE QUEST['checkbox'];
$ethnicityexpre ssion = $_REQUEST["ethnicityexpre ssion"];
$syllablesstrin g = $_REQUEST["syllablesstrin g"];
$syllable = $_REQUEST["syllablesstrin g"];
$minletters = $_REQUEST["minletters "];
$maxletters = $_REQUEST["maxletters "];
$namelength = $_REQUEST["namelength "];
$topbabynames = $_REQUEST["topbabynam es"];
$numberofsyllab les=$_REQUEST["numberofsyllab les"];
$check1=$_REQUE ST['bab'];
$check2=$_REQUE ST['cp'];
$baby=$_REQUEST['recsno'];
$baby1=$_REQUES T['endno'];
$data=trim($bab y);
$ex=explode(" ",$data);
$size1=sizeof($ ex);
$data1=trim($ba by1);
$checkend=explo de(" ",$data1);
$size=sizeof($c heckend);
//}
// print_r($checke nd);
//echo $sql="DELETE FROM person_records WHERE User_id='$check b";
//$result=mysql_q uery($sql) or die(mysql_error ());
//print_r ($check1);
$namebegins=$_R EQUEST['namebegins'];
// }
if ($displaypage != 0 ) {
// need to replace stars with apostrophes so is passed properly from hidden form
$namebeginsexpr ession = ereg_replace(": ", "'", $namebeginsexpr ession);
$nameendsexpres sion = ereg_replace(": ", "'", $nameendsexpres sion);
$ethnicityexpre ssion = ereg_replace(": ", "'", $ethnicityexpre ssion);
$query = ereg_replace(": ", "'", $query);
// need to replace stars with apostrophes so is passed properly from hidden form
}
//echo $displaypage."R avi--";
/*if ($displaypage == 0 ) {
$index = 0;
$syllablesstrin g = "";//'(';
while ($index < 5) {
$numberofsyllab les[$index] = strip_tags($num berofsyllables[$index]);
if ($numberofsylla bles[$index] != '') {
$syllablesstrin g = $syllablesstrin g . $numberofsyllab les[$index];
// else $syllablesstrin g = $syllablesstrin g .', '. $numberofsyllab les[$index] ;
}
$index++;
}
*/
if (strlen($syllab lesstring) > 3) {
$syllablesstrin g = substr($syllabl esstring, 0, -2);
}
//$syllablesstrin g = $syllablesstrin g . ')';
//if ($syllablesstri ng == '()') {
if ($syllablesstri ng == '') {
$syllablesstrin g = '1, 2, 3, 4, 5, 6, 7, 8';
// $syllablesstrin g=$_REQUEST['syllablesstrin g'];
}
$index = 0;
$namebeginsexpr ession = '(';
$nameendsexpres sion = '(';
while ($index < 26) {
if ($namebegins[$index] != '') {
$namebeginsexpr ession = $namebeginsexpr ession . " `babyname` LIKE '$namebegins[$index]%' OR ";
}
if ($nameends[$index] != '') {
$nameendsexpres sion = $nameendsexpres sion . " `babyname` LIKE '%$nameends[$index]' OR ";
}
$index++;
}
if ($namebeginsexp ression != '(') {
$namebeginsexpr ession = substr($namebeg insexpression, 0, -3);
$namebeginsexpr ession = $namebeginsexpr ession . ')';
}
else {
$namebeginsexpr ession = " `babyname` LIKE '%'";
}
if ($nameendsexpre ssion != '(') {
$nameendsexpres sion = substr($nameend sexpression, 0, -3);
$nameendsexpres sion = $nameendsexpres sion . ')';
}
else {
$nameendsexpres sion = " `babyname` LIKE '%'";
}
$index = 0;
$ethnicityexpre ssion = '(';
while ($index < 30) { // 30 is the number of different origin categories, change this if need be
if ($ethnicity[$index] != '') {
$ethnicityexpre ssion = $ethnicityexpre ssion . " `origin` LIKE '$ethnicity[$index]%' OR ";
}
$index++;
}
if ($ethnicityexpr ession != '(') {
$ethnicityexpre ssion = substr($ethnici tyexpression, 0, -3);
$ethnicityexpre ssion = $ethnicityexpre ssion . ')';
}
else {
$ethnicityexpre ssion = " `origin` LIKE '%'";
}
//}
if ($minletters > $maxletters) {
$i = $maxletters;
$maxletters = $minletters;
$minletters = $i;
}
if(!isset($_GET['pageno']) || $_GET['pageno']==0)
{
$pageno=1;
}
else
$pageno=$_GET['pageno'];
$currentpage=$p ageno - 1;
$pagesize=50;
$rownum = $currentpage*$p agesize;
?>
<?php
//temporaray
//$universe = "all";
//$displaypage = 0;
//
if (isset($_GET['syllablesstrin g']))
$syllablesstrin g=$_GET['syllablesstrin g'];
if ($universe == "all") {
if ($displaypage == 0) {
//print_r($checkb );
print_r($checkb 1);
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2=="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
//$query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
//$query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpr ession . ' AND ' . $nameendsexpres sion . " AND `babyname` LIKE '%$namecontains %' AND `meaning` LIKE '%$meaningconta ins%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstrin g AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
//}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$check b1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
}
}}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check2!=""&&$c heck1=="" && $namecontains== "")
{
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
echo $babyresult=mys ql_fetch_array( $query1);
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !="") {
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
//}
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namec ontains%$checkb 1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1=="" && $check2=="" &&$namecontains !="")
{
$query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '$namecontains% 'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
// $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$namecontains %' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
//}
else
{
//}
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
if ($universe == "top")
{
if ($displaypage == 0) {
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2=="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
//$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}
}
// echo $query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpr ession . ' AND ' . $nameendsexpres sion . " AND `babyname` LIKE '%$namecontains %' AND `meaning` LIKE '%$meaningconta ins%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstrin g AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains =="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
$query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$check b1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check2!=""&&$c heck1=="" && $namecontains== "")
{
for($j=0;$j<$si ze1;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !="")
{
for($i=0;$i<$si ze1;$i++)
{
$checkb=trim($e x[$i]);
for($j=0;$j<$si ze;$j++)
{
$checkb1=trim($ checkend[$j]);
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gen der FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namec ontains%$checkb 1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$babyresult=mys ql_fetch_array( $query1);
}
}
}
if($numberofsyl lables != 0 && $numberofsyllab les != 5 && $check1!="" && $check2!="" &&$namecontains !=""){
$query="SELECT babyname, upper( babyname ) AS thebabyname ,gender FROM `namesdb`WHERE `babyname` LIKE '%$namecontains %' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstri ng) AND length(trim(bab yname)) >= $minletters AND length(trim(bab yname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
}
else
{
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
}
$query1=mysql_q uery($query);
$row=mysql_num_ rows($query1);
//}
$numberofrows =$row;
// echo $genderis;
$babyresult=mys ql_fetch_array( $query1);
}
///-------- 20-------------------------------------------------------------------------
if(isset($pages ize) && $pagesize!="")
{
$data2 =$query." LIMIT $rownum, $pagesize";
$product_query1 = mysql_query($da ta2);
}//----------------------------------------//////////////---------------------------------------------------------------
$total=mysql_nu m_rows($query1) ;
//echo $pagesize;
$movepage=floor ($total/$pagesize);
$move=$total%$p agesize;
if($move !=0)
$movepage=$move page+1;
if($movepage <1)
{ $movepage = 1; }
//---------------------------------------------------------------------------------
$row=mysql_num_ rows($query1);
$numberofrows =$row;
$row1=mysql_num _rows($product_ query1);
?>
<body>
<tr>
<td><strong>Pag e <?=$pageno?> of your search results.</strong></td>
</tr>
<tr><td>Page <?=$pageno?> of <?=$movepage? > pages.</td>
</tr>
<tr><td><tr>
<td><span class="text_hea ding" style="padding-right:20px">
<?php if ($pageno>1)
{?>
< <!--<a href="baby-names-results.php?pag eno=<?//=$pageno-1?>&genderi s=<?//=$gender?>& ethnicity=<?//=$ethnicity?>&a mp;syllablesstr ing=<?//=$syllablesstri ng?>&minlet ters=<?//=$minletters?>& amp;maxletters= <?//=$maxletters?>& amp;meaningcont ains=<?//=$meaningcontai ns?>&checkb ox=<?//=$_REQUEST['checkbox']?>&namecont ains=<?//=$namecontains? >&displaypa ge=<?//=$_REQUEST["displaypag e"]?>&universe =<?//=//$_REQUEST["universe"]?>&bab=<?//=$_REQUEST['recsno'];?>&cp=<?//=$_REQUEST['endno']?>&namebegi ns=<?//=$_REQUEST['namebegins']?>" class="link">Pr evious</a>--->
<a href="baby-names-results.php?pag eno=<?=$pageno-1?>&genderis=<? =$gender?>ðn icity=<?=$ethni city?>&syllable sstring=<?=$syl lablesstring?>& minletters=<?=$ minletters?>&ma xletters=<?=$ma xletters?>&mean ingcontains=<?= $meaningcontain s?>&//checkbox=<?=$_R EQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>"&namebegins =<?=$_REQUEST['namebegins']?>" class="link">Pr evious</a>
<? } ?>
<?php
$end=20;
if ($pageno>20) $start=($pageno-20)+1;
if ($movepage<20) $end=$movepage;
if ($movepage>20 && $pageno>20) $end=$pageno;
// $start
for($pg=$start; $pg<=$end;$pg++ )
{
if($pg==$pageno ) echo "<strong>".$pg. "</strong> ";
else {?>
<a class="link" href="baby-names-results.php?pag eno=<?php echo $pg; ?>ðnicity=<? =$ethnicity?>&g enderis=<?=$gen der?>&syllables string=<?=$syll ablesstring?>&m inletters=<?=$m inletters?>&max letters=<?=$max letters?>&meani ngcontains=<?=$ meaningcontains ?>&checkbox=<?= $_REQUEST['checkbox']?>&namecontains =<?=$namecontai ns?>&displaypag e=<?=$_REQUEST["displaypag e"]?>&universe=<?= $_REQUEST["universe"]?>&bab=<?=$_REQ UEST['bab'];?>&cp=<?=$_REQ UEST['cp']?>&baby=<?=$_RE QUEST['recsno'];?>&baby1=<?=$_ REQUEST['endno'];?>&namebegins= <?=$_REQUEST['namebegins']?>"><strong><?p hp echo $pg; ?></strong></a>
<?php
} }
?>
<?php if ($pageno<$movep age)
{ ?>
<a href="baby-names-results.php?pag eno=<?=$pageno+ 1?>&ethnici ty=<?=$ethnicit y?>&genderi s=<?=$gender?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Ne xt</a>>
<? } ?>
</span></td>
</tr>
<?php
if($row1>0)
{
while($babyresu lt=mysql_fetch_ array($product_ query1))
{
?>
<tr>
<td id="td-col"> </tr>
<tr><td>
<table width="391" border="0" cellspacing="1" cellpadding="1" id="table-inner">
<tr>
<td id="td-col"> </tr>
<tr>
<!---<td rowspan="2"><im g src="/pet-includes/pet-names-u.gif"></td>--->
<td id="td-col"><a href='http://www.yeahbaby.co m/baby-name.php?name=< ?=$babyname?>'> <strong><?=$bab yname ?></strong></a> </tr>
<tr>
<td><? $babyname = $babyresult['babyname'];?></td>
</tr>
<tr>
<td><? $thebabyname = ucfirst(strtolo wer($thebabynam e));?></td>
</tr>
<tr>
<td><? $gender=$babyre sult1['gender'];?></td>
</tr>
</table></td></tr>
<?
/*echo $babyname = $babyresult['babyname'];
$thebabyname = $babyresult['thebabyname'];
$thebabyname = ucfirst(strtolo wer($thebabynam e));
$namelength = $babyresult['babynamlen'];
*/
$displaypage++;
}}?>
<tr>
<td><span class="text_hea ding" style="padding-right:20px">
<?php if ($pageno>1){?>
< <a href="baby-names-results.php?pag eno=<?=$pageno-1?>&genderi s=<?=$gender?>& amp;ethnicity=< ?=$ethnicity?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Pr evious</a>
<? } ?>
<?php
$end=20;
if ($pageno>20) $start=($pageno-20)+1;
if ($movepage<20) $end=$movepage;
if ($movepage>20 && $pageno>20) $end=$pageno;
// $start
for($pg=$start; $pg<=$end;$pg++ )
{
if($pg==$pageno ) echo "<strong>".$pg. "</strong> ";
else {?>
<a class="link" href="baby-names-results.php?pag eno=<?php echo $pg; ?>ðnicity=<? =$ethnicity?>&g enderis=<?=$gen der?>&syllables string=<?=$syll ablesstring?>&m inletters=<?=$m inletters?>&max letters=<?=$max letters?>&meani ngcontains=<?=$ meaningcontains ?>&namecontains =<?=$namecontai ns?>&displaypag e=<?=$_REQUEST["displaypag e"]?>&universe=<?= $_REQUEST["universe"]?>&bab=<?=$_REQ UEST['bab'];?>&cp=<?=$_REQ UEST['cp']?>&baby=<?=$_RE QUEST['recsno'];?>&baby1=<?=$_ REQUEST['endno'];?>&namebegins= <?=$_REQUEST['namebegins']?>"><strong><?p hp echo $pg; ?></strong></a>
<?php
} }
?>
<?php if ($pageno<$movep age){ ?>
<a href="baby-names-results.php?pag eno=<?=$pageno+ 1?>&ethnici ty=<?=$ethnicit y?>&genderi s=<?=$gender?>& amp;syllablesst ring=<?=$syllab lesstring?>& ;minletters=<?= $minletters?>&a mp;maxletters=< ?=$maxletters?> &meaningcon tains=<?=$meani ngcontains?>&am p;checkbox=<?=$ _REQUEST['checkbox']?>&namecont ains=<?=$nameco ntains?>&di splaypage=<?=$_ REQUEST["displaypag e"]?>&universe =<?=$_REQUEST["universe"]?>&bab=<?=$ _REQUEST['bab'];?>&cp=<?=$ _REQUEST['cp']?>&baby=<?= $_REQUEST['recsno'];?>&baby1=< ?=$_REQUEST['endno'];?>&namebeg ins=<?=$_REQUES T['namebegins']?>" class="link">Ne xt</a>>
<? } ?>
</span></td>
</tr><?
these are codes ,so please solve my problem why the content(data)of last page show on first page
thanks
Chitta Ranjan
Software Engineer