I am using a form to post to search with about 5 different variables, my pages do not hold the search values. do I need to add a redirect page in there to set the variables, then move to the search. I have been reading in here abit about it and that seems like the most logical solution for this is the redirect page. Anyone have any ideas on how to do this. Here is the code I am using after they enter in there values and press search.
<?
mysql_connect("");
mysql_select_db("");
$search_make = $_POST['MAKE'];
$search_model = $_POST['MODEL'];
$search_minyear = $_POST['MINYEAR'];
$search_maxyear = $_POST['MAXYEAR'];
$search_miles = $_POST['MILES'];
$search_minprice = $_POST['MINPRICE'];
$search_maxprice = $_POST['MAXPRICE'];
$search_category = $_POST['CATEGORY'];
$_REQUEST['page'];
if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}
$max_results = 25;
$from = (($page * $max_results) - $max_results);
$query = "SELECT * FROM inventory WHERE TYPE = 'U' AND ACTIVE='1'";
if($search_make){
$query.=" AND MAKE LIKE '%$search_make%' ";
}
if($search_model){
$query.=" AND MODEL LIKE '$search_model' ";
}
if($search_minyear){
$query.=" AND (YEAR BETWEEN '$search_minyear' AND '$search_maxyear')";
}
if($search_miles){
$query.=" AND MILEAGE < '$search_miles' ";
}
if($search_minprice){
$query.=" AND (PRICE BETWEEN '$search_minprice' AND '$search_maxprice')";
}
if($search_category){
$query.=" AND CATEGORY = '$search_category' ";
}
$query.=" ORDER BY YEAR DESC, MAKE, CATEGORY ASC, MODEL ASC LIMIT $from, $max_results";
$result=mysql_query($query);
echo "<table width='95%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='608' height='48'>
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='262'><font color='FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Year
Make Model</font></td>
<td width='90'><div align='center'><font color='FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Stock #</font></div></td>
<td width='90'><div align='center'><font color='FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Color</font></div></td>
<td width='97'><div align='center'><font color='FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Mileage</font></div></td>
<td width='118'><div align='center'><font color='FFFFFF' size='2' face='Verdana, Arial, Helvetica, sans-serif'>Price</font></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td width='166'> </td>
</tr>
</table>";
$bgcolor = "#E0E0E0"; // light gray
while($row = mysql_fetch_array($result)){
if ($bgcolor == "#D42023"){
$bgcolor = "#C61D20";
$fontcolor = "#FFFFFF";
}else{
$bgcolor = "#D42023";
$fontcolor = "#FFFFFF";
}
$vin = $row["VIN"];
$imagelocation = $row["IMAGE_LOCATION"];
$price = $row["PRICE"];
$english = number_format($price);
echo "<table width='95%' border='0' cellspacing='0' cellpadding='0' bgcolor=".$bgcolor.">
<tr>
<td width='608'><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td><table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td width='262'><font color= ".$fontcolor." size='2' face='Verdana, Arial, Helvetica, sans-serif'><a href='viewinventory.php?vin=$vin' onclick=\"NewWindow(this.href,'name','810','500','yes');return false\">{$row["YEAR"]}
{$row["MAKE"]} {$row["MODEL"]}</a></font></td>
<td width='90'><div align='center'><font color=".$fontcolor." size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["STOCK"]}</font></div></td>
<td width='90'><div align='center'><font color=".$fontcolor." size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["EXTERIORCOLOR"]}</font></div></td>
<td width='97'><div align='center'><font color=".$fontcolor." size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$row["MILEAGE"]} Miles</font></div></td>
<td width='118'><div align='center'><font color=".$fontcolor." size='2' face='Verdana, Arial, Helvetica, sans-serif'>"; ?>$<? print"$english</font></div></td>
</tr>
</table></td>
</tr>
</table></td>
<td width='166' align='right'><a href='viewinventory.php?vin=$vin' onclick=\"NewWindow(this.href,'name','810','500','yes');return false\"><img src='images/cars/$imagelocation' width='72'></a></a></td>
</tr>
</table>";
}
echo "<div align='right'>";
// Figure out the total number of results in DB:
$query1 = "SELECT COUNT(*) as Num FROM inventory WHERE TYPE = 'U' AND ACTIVE='1'";
if($search_make){
$query1.=" AND MAKE LIKE '%$search_make%' ";
}
if($search_model){
$query1.=" AND MODEL LIKE '$search_model' ";
}
if($search_minyear){
$query1.=" AND (YEAR BETWEEN '$search_minyear' AND '$search_maxyear')";
}
if($search_miles){
$query1.=" AND MILEAGE < '$search_miles' ";
}
if($search_minprice){
$query1.=" AND (PRICE BETWEEN '$search_minprice' AND '$search_maxprice')";
}
if($search_category){
$query1.=" AND CATEGORY = '$search_category' ";
}
$query1.=" ORDER BY YEAR DESC, MAKE, MODEL ASC ";
$total_results = mysql_result(mysql_query($query1),0);
// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);
// Build Previous Link
if($page > 1){
$prev = ($page - 1);
echo "<a href=\"preownedsearch.php?page=$prev\"><<Previous Page</a> ";
}
for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a href=\"preownedsearch.php?page=$i\">$i</a> ";
}
}
// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "<a href=\"preownedsearch.php?page=$next\">Next Page>></a>";
}
echo "</center></div>";
Thanks for any help
