require_once 'Connections/shockdude.php'; mysql_select_db ($database_shockdude); if ($_POST["usrYear"] != $_POST["prevYear"]) { $changedYear=true; } else { $changedYear=false; } if ($_POST["usrMake"] != $_POST["prevMake"]) { $changedMake=true; } else { $changedMake=false; } if (( $_POST["usrYear"] != "" && $_POST["usrYear"] !="0") && ($_POST["usrMake"] != "" && $_POST["usrMake"] !="0") && ($_POST["usrModel"] != "" && $_POST["usrModel"] !="0" && $changedYear==false && $changedMake==false )) { Header("Location: catalog/advanced_search_result.php?keywords=%25&year=".$_POST["usrYear"]."&make=".$_POST["usrMake"]."&model=".$_POST["usrModel"]); die; } $sqlYear = "SELECT distinct car_year from YearMakeModel order by car_year"; $yearresult=mysql_query($sqlYear) or die ('Year query failed: '.mysql_error()); if ($_POST["usrYear"] != "" && $_POST["usrYear"] !="0") { $sqlMake = "SELECT distinct car_make from YearMakeModel WHERE car_year = '".$_POST["usrYear"]."' order by car_make"; $makeresult=mysql_query($sqlMake) or die ('Make query failed: '.mysql_error()); } if ($_POST["usrMake"] != "" && $_POST["usrMake"] !="0" && $changedYear==false) { $sqlModel = "SELECT distinct car_model from YearMakeModel WHERE car_year = '".$_POST["usrYear"]."' and car_make = '".$_POST["usrMake"]."' order by car_model"; $modelresult=mysql_query($sqlModel) or die ('Model query failed: '.mysql_error()); } ?>
![]() |
||||||||
![]() |
||||||||
![]() |
||||||||
|
||||||||
|
||||||||