473,387 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

pagging

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.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">


<?php
//print_r($_REQUEST);
$chanid = 1;

include "dbconnect.php";

$page = $_REQUEST["page"];
//if(isset($_POST['submit']))
//{
//echo $text=$_POST['namecontains'];
//$text1=$_POST['meaningcontains'];
//}
?>
<head>


<title>Your baby name search results - YeahBaby.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" 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.com/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="javascript">
document.form1.action="baby-names-results.php?recsno="+$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.com" title="baby names">YeahBaby.com</a> &gt;
<a href="http://www.yeahbaby.com/baby-names-search.php" title="baby names search">Advanced Names Search</a> &gt;
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>&nbsp;</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=$_REQUEST["universe"];

$namecontains = $_REQUEST["namecontains"];


$namecontains = strip_tags($namecontains);

$meaningcontains = $_REQUEST["meaningcontains"];

$meaningcontains = strip_tags($meaningcontains);

$genderis = $_REQUEST["genderis"];

$gender = $_REQUEST["genderis"];

$genderis = strip_tags($genderis);

$displaypage = $_REQUEST["displaypage"];

$namebeginsexpression = $_REQUEST["namebeginsexpression"];

$ethnicity=$_REQUEST['checkbox'];

$ethnicityexpression = $_REQUEST["ethnicityexpression"];

$syllablesstring = $_REQUEST["syllablesstring"];

$syllable = $_REQUEST["syllablesstring"];

$minletters = $_REQUEST["minletters"];

$maxletters = $_REQUEST["maxletters"];

$namelength = $_REQUEST["namelength"];

$topbabynames = $_REQUEST["topbabynames"];

$numberofsyllables=$_REQUEST["numberofsyllables"];

$check1=$_REQUEST['bab'];

$check2=$_REQUEST['cp'];

$baby=$_REQUEST['recsno'];

$baby1=$_REQUEST['endno'];


$data=trim($baby);

$ex=explode(" ",$data);

$size1=sizeof($ex);


$data1=trim($baby1);

$checkend=explode(" ",$data1);

$size=sizeof($checkend);

//}

// print_r($checkend);

//echo $sql="DELETE FROM person_records WHERE User_id='$checkb";
//$result=mysql_query($sql) or die(mysql_error());




//print_r ($check1);



$namebegins=$_REQUEST['namebegins'];
// }
if ($displaypage != 0 ) {
// need to replace stars with apostrophes so is passed properly from hidden form
$namebeginsexpression = ereg_replace(":", "'", $namebeginsexpression);

$nameendsexpression = ereg_replace(":", "'", $nameendsexpression);

$ethnicityexpression = ereg_replace(":", "'", $ethnicityexpression);

$query = ereg_replace(":", "'", $query);
// need to replace stars with apostrophes so is passed properly from hidden form
}
//echo $displaypage."Ravi--";
/*if ($displaypage == 0 ) {

$index = 0;

$syllablesstring = "";//'(';

while ($index < 5) {

$numberofsyllables[$index] = strip_tags($numberofsyllables[$index]);

if ($numberofsyllables[$index] != '') {
$syllablesstring = $syllablesstring . $numberofsyllables[$index];
// else $syllablesstring = $syllablesstring .', '. $numberofsyllables[$index] ;

}

$index++;

}
*/
if (strlen($syllablesstring) > 3) {

$syllablesstring = substr($syllablesstring, 0, -2);

}

//$syllablesstring = $syllablesstring . ')';

//if ($syllablesstring == '()') {
if ($syllablesstring == '') {

$syllablesstring = '1, 2, 3, 4, 5, 6, 7, 8';
// $syllablesstring=$_REQUEST['syllablesstring'];

}

$index = 0;

$namebeginsexpression = '(';

$nameendsexpression = '(';

while ($index < 26) {

if ($namebegins[$index] != '') {

$namebeginsexpression = $namebeginsexpression . " `babyname` LIKE '$namebegins[$index]%' OR ";

}

if ($nameends[$index] != '') {

$nameendsexpression = $nameendsexpression . " `babyname` LIKE '%$nameends[$index]' OR ";

}

$index++;

}

if ($namebeginsexpression != '(') {

$namebeginsexpression = substr($namebeginsexpression, 0, -3);

$namebeginsexpression = $namebeginsexpression . ')';

}

else {

$namebeginsexpression = " `babyname` LIKE '%'";

}

if ($nameendsexpression != '(') {

$nameendsexpression = substr($nameendsexpression, 0, -3);

$nameendsexpression = $nameendsexpression . ')';

}

else {

$nameendsexpression = " `babyname` LIKE '%'";

}


$index = 0;

$ethnicityexpression = '(';

while ($index < 30) { // 30 is the number of different origin categories, change this if need be

if ($ethnicity[$index] != '') {

$ethnicityexpression = $ethnicityexpression . " `origin` LIKE '$ethnicity[$index]%' OR ";

}

$index++;

}

if ($ethnicityexpression != '(') {

$ethnicityexpression = substr($ethnicityexpression, 0, -3);

$ethnicityexpression = $ethnicityexpression . ')';

}

else {

$ethnicityexpression = " `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=$pageno - 1;
$pagesize=50;
$rownum = $currentpage*$pagesize;


?>



<?php
//temporaray
//$universe = "all";
//$displaypage = 0;
//
if (isset($_GET['syllablesstring']))

$syllablesstring=$_GET['syllablesstring'];

if ($universe == "all") {


if ($displaypage == 0) {



//print_r($checkb);
print_r($checkb1);

if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2=="" &&$namecontains=="")
{
for($i=0;$i<$size1;$i++)
{

$checkb=trim($ex[$i]);

echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

//$query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$babyresult=mysql_fetch_array($query1);

}

//$query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpression . ' AND ' . $nameendsexpression . " AND `babyname` LIKE '%$namecontains%' AND `meaning` LIKE '%$meaningcontains%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstring AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";


}
//}

if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2!="" &&$namecontains=="")
{
for($i=0;$i<$size1;$i++)
{

$checkb=trim($ex[$i]);
for($j=0;$j<$size;$j++)
{
$checkb1=trim($checkend[$j]);

echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$babyresult=mysql_fetch_array($query1);
}
}

}}

if($numberofsyllables != 0 && $numberofsyllables != 5 && $check2!=""&&$check1=="" && $namecontains=="")
{
for($j=0;$j<$size;$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 ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

echo $babyresult=mysql_fetch_array($query1);
}
}

if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2!="" &&$namecontains!="") {

for($i=0;$i<$size1;$i++)
{

$checkb=trim($ex[$i]);

for($j=0;$j<$size;$j++)
{
$checkb1=trim($checkend[$j]);
//}
echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namecontains%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$babyresult=mysql_fetch_array($query1);
}

}
}

if($numberofsyllables != 0 && $numberofsyllables != 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 ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $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 ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

//}
else
{

//}



$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$numberofrows =$row;
// echo $genderis;
$babyresult=mysql_fetch_array($query1);
}
}

if ($universe == "top")
{


if ($displaypage == 0) {


if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2=="" &&$namecontains=="")
{

for($i=0;$i<$size1;$i++)
{
$checkb=trim($ex[$i]);

echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%'AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

//$numberofrows =$row;

$babyresult=mysql_fetch_array($query1);

}
}


// echo $query = "SELECT babyname, upper(babyname) as thebabyname FROM `namesdb` WHERE " . $namebeginsexpression . ' AND ' . $nameendsexpression . " AND `babyname` LIKE '%$namecontains%' AND `meaning` LIKE '%$meaningcontains%' AND `gender` LIKE '$genderis' AND `syllables` in $syllablesstring AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";


if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2!="" &&$namecontains=="")
{
for($i=0;$i<$size1;$i++)
{
$checkb=trim($ex[$i]);

for($j=0;$j<$size;$j++)
{
$checkb1=trim($checkend[$j]);


$query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";
$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$numberofrows =$row;
// echo $genderis;
$babyresult=mysql_fetch_array($query1);
}
}
}


if($numberofsyllables != 0 && $numberofsyllables != 5 && $check2!=""&&$check1=="" && $namecontains=="")
{
for($j=0;$j<$size1;$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 ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$numberofrows =$row;

$babyresult=mysql_fetch_array($query1);


}}

if($numberofsyllables != 0 && $numberofsyllables != 5 && $check1!="" && $check2!="" &&$namecontains!="")
{

for($i=0;$i<$size1;$i++)
{
$checkb=trim($ex[$i]);

for($j=0;$j<$size;$j++)
{
$checkb1=trim($checkend[$j]);


echo $query="SELECT babyname, upper( babyname ) AS thebabyname,gender FROM `namesdb`WHERE `babyname` LIKE '$checkb%$namecontains%$checkb1' AND `gender` LIKE '$genderis%'AND `syllables` in ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$numberofrows =$row;

$babyresult=mysql_fetch_array($query1);
}
}
}

if($numberofsyllables != 0 && $numberofsyllables != 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 ($syllablesstring) AND length(trim(babyname)) >= $minletters AND length(trim(babyname)) <= $maxletters GROUP BY babyname ORDER BY thebabyname";

}
else
{
$query1=mysql_query($query);

$row=mysql_num_rows($query1);

$numberofrows =$row;
// echo $genderis;
$babyresult=mysql_fetch_array($query1);
}

}

$query1=mysql_query($query);
$row=mysql_num_rows($query1);
//}
$numberofrows =$row;
// echo $genderis;
$babyresult=mysql_fetch_array($query1);
}

///-------- 20-------------------------------------------------------------------------
if(isset($pagesize) && $pagesize!="")
{
$data2 =$query." LIMIT $rownum, $pagesize";
$product_query1 = mysql_query($data2);
}//----------------------------------------//////////////---------------------------------------------------------------

$total=mysql_num_rows($query1);
//echo $pagesize;
$movepage=floor($total/$pagesize);
$move=$total%$pagesize;
if($move !=0)
$movepage=$movepage+1;
if($movepage <1)
{ $movepage = 1; }
//---------------------------------------------------------------------------------

$row=mysql_num_rows($query1);

$numberofrows =$row;
$row1=mysql_num_rows($product_query1);
?>

<body>
<tr>
<td><strong>Page <?=$pageno?> of your search results.</strong></td>
</tr>
<tr><td>Page <?=$pageno?> of <?=$movepage?> pages.</td>
</tr>
<tr><td><tr>
<td><span class="text_heading" style="padding-right:20px">
<?php if ($pageno>1)
{?>
&lt; <!--<a href="baby-names-results.php?pageno=<?//=$pageno-1?>&amp;genderis=<?//=$gender?>&amp;ethnicity=<?//=$ethnicity?>&amp;syllablesstring=<?//=$syllablesstring?>&amp;minletters=<?//=$minletters?>&amp;maxletters=<?//=$maxletters?>&amp;meaningcontains=<?//=$meaningcontains?>&amp;checkbox=<?//=$_REQUEST['checkbox']?>&amp;namecontains=<?//=$namecontains?>&amp;displaypage=<?//=$_REQUEST["displaypage"]?>&amp;universe=<?//=//$_REQUEST["universe"]?>&amp;bab=<?//=$_REQUEST['recsno'];?>&amp;cp=<?//=$_REQUEST['endno']?>&amp;namebegins=<?//=$_REQUEST['namebegins']?>" class="link">Previous</a>--->

<a href="baby-names-results.php?pageno=<?=$pageno-1?>&genderis=<?=$gender?>&ethnicity=<?=$ethnicity? >&syllablesstring=<?=$syllablesstring?>&minletters =<?=$minletters?>&maxletters=<?=$maxletters?>&mean ingcontains=<?=$meaningcontains?>&//checkbox=<?=$_REQUEST['checkbox']?>&amp;namecontains=<?=$namecontains?>&amp;display page=<?=$_REQUEST["displaypage"]?>&amp;universe=<?=$_REQUEST["universe"]?>&amp;bab=<?=$_REQUEST['bab'];?>&amp;cp=<?=$_REQUEST['cp']?>&amp;baby=<?=$_REQUEST['recsno'];?>&amp;baby1=<?=$_REQUEST['endno'];?>"&namebegins=<?=$_REQUEST['namebegins']?>" class="link">Previous</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>&nbsp;";
else {?>
<a class="link" href="baby-names-results.php?pageno=<?php echo $pg; ?>&ethnicity=<?=$ethnicity?>&genderis=<?=$gender?> &syllablesstring=<?=$syllablesstring?>&minletters= <?=$minletters?>&maxletters=<?=$maxletters?>&meani ngcontains=<?=$meaningcontains?>&checkbox=<?=$_REQ UEST['checkbox']?>&namecontains=<?=$namecontains?>&displaypage=<?= $_REQUEST["displaypage"]?>&universe=<?=$_REQUEST["universe"]?>&bab=<?=$_REQUEST['bab'];?>&cp=<?=$_REQUEST['cp']?>&baby=<?=$_REQUEST['recsno'];?>&baby1=<?=$_REQUEST['endno'];?>&namebegins=<?=$_REQUEST['namebegins']?>"><strong><?php echo $pg; ?></strong></a>&nbsp;
<?php

} }

?>
<?php if ($pageno<$movepage)

{ ?>

<a href="baby-names-results.php?pageno=<?=$pageno+1?>&amp;ethnicity=<? =$ethnicity?>&amp;genderis=<?=$gender?>&amp;syllab lesstring=<?=$syllablesstring?>&amp;minletters=<?= $minletters?>&amp;maxletters=<?=$maxletters?>&amp; meaningcontains=<?=$meaningcontains?>&amp;checkbox =<?=$_REQUEST['checkbox']?>&amp;namecontains=<?=$namecontains?>&amp;display page=<?=$_REQUEST["displaypage"]?>&amp;universe=<?=$_REQUEST["universe"]?>&amp;bab=<?=$_REQUEST['bab'];?>&amp;cp=<?=$_REQUEST['cp']?>&amp;baby=<?=$_REQUEST['recsno'];?>&amp;baby1=<?=$_REQUEST['endno'];?>&amp;namebegins=<?=$_REQUEST['namebegins']?>" class="link">Next</a>&gt;

<? } ?>

</span></td>
</tr>

<?php
if($row1>0)
{
while($babyresult=mysql_fetch_array($product_query 1))
{

?>
<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"><img src="/pet-includes/pet-names-u.gif"></td>--->
<td id="td-col"><a href='http://www.yeahbaby.com/baby-name.php?name=<?=$babyname?>'><strong><?=$babyname ?></strong></a> </tr>
<tr>
<td><? $babyname = $babyresult['babyname'];?></td>
</tr>
<tr>
<td><? $thebabyname = ucfirst(strtolower($thebabyname));?></td>
</tr>
<tr>
<td><? $gender=$babyresult1['gender'];?></td>
</tr>
</table></td></tr>

<?

/*echo $babyname = $babyresult['babyname'];

$thebabyname = $babyresult['thebabyname'];

$thebabyname = ucfirst(strtolower($thebabyname));

$namelength = $babyresult['babynamlen'];
*/
$displaypage++;

}}?>
<tr>
<td><span class="text_heading" style="padding-right:20px">
<?php if ($pageno>1){?>
&lt; <a href="baby-names-results.php?pageno=<?=$pageno-1?>&amp;genderis=<?=$gender?>&amp;ethnicity=<?=$et hnicity?>&amp;syllablesstring=<?=$syllablesstring? >&amp;minletters=<?= $minletters?>&amp;maxletters=<?=$maxletters?>&amp; meaningcontains=<?=$meaningcontains?>&amp;checkbox =<?=$_REQUEST['checkbox']?>&amp;namecontains=<?=$namecontains?>&amp;display page=<?=$_REQUEST["displaypage"]?>&amp;universe=<?=$_REQUEST["universe"]?>&amp;bab=<?=$_REQUEST['bab'];?>&amp;cp=<?=$_REQUEST['cp']?>&amp;baby=<?=$_REQUEST['recsno'];?>&amp;baby1=<?=$_REQUEST['endno'];?>&amp;namebegins=<?=$_REQUEST['namebegins']?>" class="link">Previous</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>&nbsp;";
else {?>
<a class="link" href="baby-names-results.php?pageno=<?php echo $pg; ?>&ethnicity=<?=$ethnicity?>&genderis=<?=$gender?> &syllablesstring=<?=$syllablesstring?>&minletters= <?=$minletters?>&maxletters=<?=$maxletters?>&meani ngcontains=<?=$meaningcontains?>&namecontains=<?=$ namecontains?>&displaypage=<?=$_REQUEST["displaypage"]?>&universe=<?=$_REQUEST["universe"]?>&bab=<?=$_REQUEST['bab'];?>&cp=<?=$_REQUEST['cp']?>&baby=<?=$_REQUEST['recsno'];?>&baby1=<?=$_REQUEST['endno'];?>&namebegins=<?=$_REQUEST['namebegins']?>"><strong><?php echo $pg; ?></strong></a>&nbsp;
<?php

} }

?>
<?php if ($pageno<$movepage){ ?>

<a href="baby-names-results.php?pageno=<?=$pageno+1?>&amp;ethnicity=<? =$ethnicity?>&amp;genderis=<?=$gender?>&amp;syllab lesstring=<?=$syllablesstring?>&amp;minletters=<?= $minletters?>&amp;maxletters=<?=$maxletters?>&amp; meaningcontains=<?=$meaningcontains?>&amp;checkbox =<?=$_REQUEST['checkbox']?>&amp;namecontains=<?=$namecontains?>&amp;display page=<?=$_REQUEST["displaypage"]?>&amp;universe=<?=$_REQUEST["universe"]?>&amp;bab=<?=$_REQUEST['bab'];?>&amp;cp=<?=$_REQUEST['cp']?>&amp;baby=<?=$_REQUEST['recsno'];?>&amp;baby1=<?=$_REQUEST['endno'];?>&amp;namebegins=<?=$_REQUEST['namebegins']?>" class="link">Next</a>&gt;

<? } ?>

</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
Dec 18 '07 #1
0 1180

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Ricardo Manuel | last post by:
Hi, I'm using a Datagrid that I fill with a Dataset but when I configure the paging with the Navigation Buttons I can't put them working, I've tried both methods (Next, Previous and Page Numbers)...
2
by: sushil bogam via .NET 247 | last post by:
(Type your message here) hi there please help me with datagrid control i want to add a checkbox in datagrid and also want to trap the check bok check or click event and also want to maintain the...
2
by: t | last post by:
Hi, I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes:...
3
sanjay123456
by: sanjay123456 | last post by:
hello sir... plz check the coding....jsp functions are not working... Sir plz check the following code and point out me errror <? include('../include/site_config.php'); ...
3
by: PseudoMega | last post by:
I'm working with a PHP page I wrote which searches through records in a MySQL database. I have a <form method="post"which currently passes all of search variables into the session array. I'd...
5
by: hugonot | last post by:
I have got a problem with checkboxes array and the form. I have the results from table (MySQL) and checkbox (form) near the results. I use: echo "<input type=checkbox name=box value=".$.">"; for...
1
by: priyasweetypie2004 | last post by:
I have 8 lakhs email id's in my SQL -Server Database. I have to seperate valid emails from those email id and store them in seperate table. If i use select statement with 8 lakhs data the server will...
1
by: pankajprakash | last post by:
Hi I have an asp.net gridview control. I have used pagging but when I click on grid for pagging it shows the following error Error: A Runtime Error has occurred.Do you wish to Debug? Line: 4723...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.