Here is the code for the page:
<?php require_once('C onnections/test.php'); ?>
<?php
$maxRows_Record set1 = 10;
$pageNum_Record set1 = 0;
if (isset($_GET['pageNum_Record set1'])) {
$pageNum_Record set1 = $_GET['pageNum_Record set1'];
}
$startRow_Recor dset1 = $pageNum_Record set1 * $maxRows_Record set1;
$varGender_Reco rdset1 = "m";
if (isset(#formGen der#)) {
$varGender_Reco rdset1 ) (get_magic_quot es_gpc()) ? #formGender# : addslashes(#for mGender#);
}
$varAge_Records et1 = "12";
if (isset(#formAge #)) {
$varAge_Records et1 ) (get_magic_quot es_gpc()) ? #formAge# : addslashes(#for mAge#);
}
$varZipCode_Rec ordset1 = "82001";
if (isset(#formZip Code#)) {
$varZipCode_Rec ordset1 ) (get_magic_quot es_gpc()) ? #formZipCode# : addslashes(#for mZipCode#);
}
mysql_select_db ($database_test , $test);
$query_Recordse t1 = sprintf("SELECT table01.UserNam e, table01.Name, table01.Gender, table01.Age, table01.Height, table01.ZipCode , table01.Hunting , table01.Fishing FROM table01 WHERE Gender = "%s" AND Age = "%s" AND ZipCode = "%s" ORDER BY table01.Age", $varGender_Reco rdset1,$varAge_ Recordset1,$var ZipCode_Records et1);
$query_limit_Re cordset1 = sprintf("%s LIMIT %d, %d", $query_Recordse t1, $startRow_Recor dset1, $maxRows_Record set1);
$Recordset1 = mysql_query($qu ery_limit_Recor dset1, $test) or die(mysql_error ());
$row_Recordset1 = mysql_fetch_ass oc($Recordset1) ;
if (isset($_GET['totalRows_Reco rdset1'])) {
$totalRows_Reco rdset1 = $_GET['totalRows_Reco rdset1'];
} else {
$all_Recordset1 = mysql_query($qu ery_Recordset1) ;
$totalRows_Reco rdset1 = mysql_num_rows( $all_Recordset1 );
}
$totalPages_Rec ordset1 = ceil($totalRows _Recordset1/$maxRows_Record set1)-1;
?><!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitl ed Document</title>
</head>
<body>
<br />
Here are your search results... <br />
<br />
<table border="1">
<tr>
<td>Name</td>
<td>Email</td>
<td>Gender</td>
<td>Age</td>
<td>MStatus</td>
<td>Height</td>
<td>ZipCode</td>
<td>Hunting</td>
<td>Fishing</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Email']; ?></td>
<td><?php echo $row_Recordset1['Gender']; ?></td>
<td><?php echo $row_Recordset1['Age']; ?></td>
<td><?php echo $row_Recordset1['MStatus']; ?></td>
<td><?php echo $row_Recordset1['Height']; ?></td>
<td><?php echo $row_Recordset1['ZipCode']; ?></td>
<td><?php echo $row_Recordset1['Hunting']; ?></td>
<td><?php echo $row_Recordset1['Fishing']; ?></td>
</tr>
<?php } while ($row_Recordset 1 = mysql_fetch_ass oc($Recordset1) ); ?>
</table>
</body>
</html>
<?php
mysql_free_resu lt($Recordset1) ;
?>
<?php require_once('C onnections/test.php'); ?>
<?php
$maxRows_Record set1 = 10;
$pageNum_Record set1 = 0;
if (isset($_GET['pageNum_Record set1'])) {
$pageNum_Record set1 = $_GET['pageNum_Record set1'];
}
$startRow_Recor dset1 = $pageNum_Record set1 * $maxRows_Record set1;
$varGender_Reco rdset1 = "m";
if (isset(#formGen der#)) {
$varGender_Reco rdset1 ) (get_magic_quot es_gpc()) ? #formGender# : addslashes(#for mGender#);
}
$varAge_Records et1 = "12";
if (isset(#formAge #)) {
$varAge_Records et1 ) (get_magic_quot es_gpc()) ? #formAge# : addslashes(#for mAge#);
}
$varZipCode_Rec ordset1 = "82001";
if (isset(#formZip Code#)) {
$varZipCode_Rec ordset1 ) (get_magic_quot es_gpc()) ? #formZipCode# : addslashes(#for mZipCode#);
}
mysql_select_db ($database_test , $test);
$query_Recordse t1 = sprintf("SELECT table01.UserNam e, table01.Name, table01.Gender, table01.Age, table01.Height, table01.ZipCode , table01.Hunting , table01.Fishing FROM table01 WHERE Gender = "%s" AND Age = "%s" AND ZipCode = "%s" ORDER BY table01.Age", $varGender_Reco rdset1,$varAge_ Recordset1,$var ZipCode_Records et1);
$query_limit_Re cordset1 = sprintf("%s LIMIT %d, %d", $query_Recordse t1, $startRow_Recor dset1, $maxRows_Record set1);
$Recordset1 = mysql_query($qu ery_limit_Recor dset1, $test) or die(mysql_error ());
$row_Recordset1 = mysql_fetch_ass oc($Recordset1) ;
if (isset($_GET['totalRows_Reco rdset1'])) {
$totalRows_Reco rdset1 = $_GET['totalRows_Reco rdset1'];
} else {
$all_Recordset1 = mysql_query($qu ery_Recordset1) ;
$totalRows_Reco rdset1 = mysql_num_rows( $all_Recordset1 );
}
$totalPages_Rec ordset1 = ceil($totalRows _Recordset1/$maxRows_Record set1)-1;
?><!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitl ed Document</title>
</head>
<body>
<br />
Here are your search results... <br />
<br />
<table border="1">
<tr>
<td>Name</td>
<td>Email</td>
<td>Gender</td>
<td>Age</td>
<td>MStatus</td>
<td>Height</td>
<td>ZipCode</td>
<td>Hunting</td>
<td>Fishing</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['Name']; ?></td>
<td><?php echo $row_Recordset1['Email']; ?></td>
<td><?php echo $row_Recordset1['Gender']; ?></td>
<td><?php echo $row_Recordset1['Age']; ?></td>
<td><?php echo $row_Recordset1['MStatus']; ?></td>
<td><?php echo $row_Recordset1['Height']; ?></td>
<td><?php echo $row_Recordset1['ZipCode']; ?></td>
<td><?php echo $row_Recordset1['Hunting']; ?></td>
<td><?php echo $row_Recordset1['Fishing']; ?></td>
</tr>
<?php } while ($row_Recordset 1 = mysql_fetch_ass oc($Recordset1) ); ?>
</table>
</body>
</html>
<?php
mysql_free_resu lt($Recordset1) ;
?>