Can someone please help me? I need to figure out my 3rd query on this script. I'm trying to get my select year drop down box to work in this example http://75.179.9.75/cars20.php
<SCRIPT language=JavaScript>
function reload1(form)
{
var val=form.make.options[form.make.options.selectedIndex].value;
self.location='cars20.php?make=' + val ;
}
function reload2(form)
{
var val=form.make.options[form.make.options.selectedIndex].value;
var val2=form.model.options[form.model.options.selectedIndex].value;
self.location='cars20.php?make=' + val + '&model=' + val2 ;
}
</script>
</head>
<body>
<?
// ==================================================================
// GETTING THE DATA FROM MYSQL TABLE FOR THE FIRST DROP DOWN LIST BOX
// ==================================================================
$quer1=mysql_query("SELECT DISTINCT Make,Make_ID FROM v_make order by Make");
// ==========================================================
// END OF QUERY FOR THE FIRST vehicle_type DROP DOWN LIST BOX
// ==========================================================
// =============================================================================================
// FOR SECOND DROP DOWN LIST CHECK IF vehicle_make IS SELECTED ELSE DISPLAY ALL THE vehicle_model
// =============================================================================================
$Make=$HTTP_GET_VARS['make']; // This line is added to take care if the global variable is off
if(isset($Make) and strlen($Make) > 0){
$quer2=mysql_query("SELECT DISTINCT Model,Model_ID FROM v_model where Make_ID=$Make order by Model");
}else{$quer2=mysql_query("SELECT DISTINCT Model,Model_ID FROM Model order by Model"); }
// ===========================================================
// END OF QUERY FOR THE SECOND vehicle_make DROP DOWN LIST BOX
// ===========================================================
// =============================================================================================
// FOR THIRD DROP DOWN LIST CHECK IF vehicle_model IS SELECTED ELSE DISPLAY ALL THE vehicle_year
// =============================================================================================
$Model=$HTTP_GET_VARS['model']; // This line is added to take care if the global variable is off
if(isset($Model) and strlen($Model) > 0){
$quer3=mysql_query("SELECT v_year.Year FROM v_year LEFT JOIN v_year_ref ON v_year.Year_ID=v_year_ref.Year_ID WHERE v_year_ref.Model_ID=$Model");
}else{$quer3=mysql_query("SELECT DISTINCT Year FROM Year order by Year"); }
// ===========================================================
// END OF QUERY FOR THE THIRD vehicle_model DROP DOWN LIST BOX
// ===========================================================
echo "<form method=post name=f1 action=''>";
// =============================
// START OF FIRST DROP DOWN LIST
// =============================
echo "<select name='make' style=\"font-family: Tahoma; font-size: 10pt; height:28px;width:184px;\" onchange=\"reload1(this.form)\"><option value=''>- Select Make -</option>";
while($noticia1 = mysql_fetch_array($quer1)) {
if($noticia1['Make_ID']==@$Make){echo "<option selected value='$noticia1[Make_ID]'>$noticia1[Make]</option>"."<BR>";}
else{echo "<option value='$noticia1[Make_ID]'>$noticia1[Make]</option>";}
}
echo "</select><br>";
// ===============================
// END OF THE FIRST DROP DOWN LIST
// ===============================
// ==============================
// START OF SECOND DROP DOWN LIST
// ==============================
echo "<select name='model' style=\"font-family: Tahoma; font-size: 10pt; height:28px;width:184px;\" onchange=\"reload2(this.form)\"><option value=''>- Select Model -</option>";
while($noticia2 = mysql_fetch_array($quer2)) {
if($noticia2['Model_ID']==@$Model){echo "<option selected value='$noticia2[Model_ID]'>$noticia2[Model]</option>"."<BR>";}
else{echo "<option value='$noticia2[Model_ID]'>$noticia2[Model]</option>";}
}
echo "</select><br>";
// ================================
// END OF THE SECOND DROP DOWN LIST
// ================================
// ==============================
// START OF THIRD DROP DOWN LIST
// ==============================
echo "<select name='year' style=\"font-family: Tahoma; font-size: 10pt; height:28px;width:184px;\"><option value=''>- Select Year -</option>";
while($noticia3 = mysql_fetch_array($quer3)) {
echo "<option value='$noticia4[Year]'>$noticia4[Year]</option>";
}
echo "</select>";
// ================================
// END OF THE THIRD DROP DOWN LIST
// ================================
echo "</form>";
Here is how my SQL tables are setup.
INSERT INTO `v_make` (`Make_ID`, `Make`) VALUES
(1, 'Acura'),
(2, 'Buick'),
(3, 'Cadillac'),
(4, 'Chevrolet'),
(5, 'Chrysler'),
(6, 'Dodge'),
(7, 'Ford'),
(8, 'Geo'),
(9, 'GMC'),
(10, 'Honda'),
(11, 'Hyundai'),
(12, 'Infiniti'),
(13, 'Isuzu'),
(14, 'Jeep'),
(15, 'Kia'),
(16, 'Lexus'),
(17, 'Lincoln'),
(18, 'Mazda'),
(19, 'Mercury'),
(20, 'Mitsubishi'),
(21, 'Nissan'),
(22, 'Oldsmobile'),
(23, 'Plymouth'),
(24, 'Pontiac'),
(25, 'Saab'),
(26, 'Saturn'),
(27, 'Scion'),
(28, 'Subaru'),
(29, 'Suzuki'),
(30, 'Toyota');
INSERT INTO `v_model` (`Model_ID`, `Model`, `Make_ID`) VALUES
(1, CL, 1),
(2, Integra, 1),
(3, MDX, 1),
(4, RL, 1),
(5, TL, 1);
INSERT INTO `v_year` (`Year_ID`, `Year`) VALUES
(1, '2000'),
(2, '2001'),
(3, '2002'),
(4, '2003'),
(5, '2004'),
(6, '2005'),
(7, '2006'),
(8, '2007');
INSERT INTO `v_year_ref` (`Year_ID`, `Model_ID`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1);
