splitting a search into pages
Posted: Wed Jan 16, 2008 11:14 pm
Hi i have a search form which accepts three values , queries the database and displays the values of all the result in single page, i wanted to
display only 5 results per page .... Plz help me...
<<--- my code --->>
$value1=$_POST['1'];
$value2=$_POST['2'];
$value3=$_POST['3'];
$query1="select * from registration where mothertongue like '%$domain%' and religion like '%$religion%' and sex = '$sex' ";
$result=mysql_query($query1);
<?php while($row=mysql_fetch_assoc($result)){
extract ($row);
echo "<table border=1 class='black1' cellspacing='3' cellpadding='3' width='100%'> ";
echo "<tr><td class='bblack1' width='50%'>";
echo Name;
echo "</td>";
echo "<td>";
echo $firstname ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Sex;
echo "</td>";
echo "<td>";
echo $sex ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo "Date of Birth" ;
echo "</td>";
echo "<td>";
echo $dob ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo "Mother Tongue";
echo "</td>";
echo "<td>";
echo $mothertongue ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Religion;
echo "</td>";
echo "<td>";
echo $religion ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Caste;
echo "</td>";
echo "<td>";
echo $caste ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Country;
echo "</td>";
echo "<td>";
echo $country ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo State;
echo "</td>";
echo "<td>";
echo $state ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo City;
echo "</td>";
echo "<td>";
echo $city ;
echo"</td></tr></table>";
}
display only 5 results per page .... Plz help me...
<<--- my code --->>
$value1=$_POST['1'];
$value2=$_POST['2'];
$value3=$_POST['3'];
$query1="select * from registration where mothertongue like '%$domain%' and religion like '%$religion%' and sex = '$sex' ";
$result=mysql_query($query1);
<?php while($row=mysql_fetch_assoc($result)){
extract ($row);
echo "<table border=1 class='black1' cellspacing='3' cellpadding='3' width='100%'> ";
echo "<tr><td class='bblack1' width='50%'>";
echo Name;
echo "</td>";
echo "<td>";
echo $firstname ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Sex;
echo "</td>";
echo "<td>";
echo $sex ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo "Date of Birth" ;
echo "</td>";
echo "<td>";
echo $dob ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo "Mother Tongue";
echo "</td>";
echo "<td>";
echo $mothertongue ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Religion;
echo "</td>";
echo "<td>";
echo $religion ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Caste;
echo "</td>";
echo "<td>";
echo $caste ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo Country;
echo "</td>";
echo "<td>";
echo $country ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo State;
echo "</td>";
echo "<td>";
echo $state ;
echo"</td></tr>";
echo "<tr><td class='bblack1'>";
echo City;
echo "</td>";
echo "<td>";
echo $city ;
echo"</td></tr></table>";
}