OK, heres the code, for some reason I can't get the 2nd combo box to even populate now either
<html><head>
<?php
$hostname = "10.0.0.127";
$username = "lukeu";
$password = "blues7";
$database = "test";
$connection = mysql_connect($hostname , $username , $password)
or die("cannot make connection");
$db = mysql_selectdb($database , $connection)
or die("cannot find database");
$year = $GET['year'];
$query = mysql_query("select Make from MAKE where ((yr1='$year') || (yr2='$year') || (yr3='$year') || (yr4='$year') || (yr5='$year') || (yr6='$year') || (yr7='$year') || (yr8='$year') || (yr9='$year') || (yr10='$year') || (yr11='$year') || (yr12='$year') || (yr13='$year') || (yr14='$year') || (yr15='$year') || (yr16='$year') || (yr17='$year') || (yr18='$year') || (yr18='$year') || (yr20='$year') || (yr21='$year') || (yr22='$year') || (yr23='$year') || (yr24='$year') || (yr25='$year') || (yr26='$year') || (yr27='$year') || (yr28='$year') || (yr29='$year') || (yr30='$year') || (yr31='$year') || (yr32='$year') || (yr33='$year'))") or die(mysql_error());
$make = $GET['make'];
$query1 = mysql_query("select * from MODEL where (Make='$make')") or die(mysql_error());
?>
<title>Used Auto Parts - Used Salvage Yard Car Parts - Junk Yard Auto Parts</title>
<meta NAME="DESCRIPTION" CONTENT="Used Auto Parts - Used Salvage Yard Car Parts - Junk Yard Auto Parts">
<meta NAME="KEYWORDS" CONTENT="Used Auto Parts - Used Salvage Yard Car Parts - Junk Yard Auto Parts">
</head>
<body TOPMARGIN=0 leftmargin=0 bgcolor=#84b1e0>
<table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr><td colspan=2 VALIGN=top>
<img src="Images/top.jpg" ALT=Luke Urtnowski>
</td></tr>
<tr><td VALIGN="TOP">
<table CELLPADDING="0" cellspacing=0 border=0 align=left>
<tr><td>
<img SRC="Images/homedown.jpg" valign=top> <br>
<a href="locate.html" onmouseover="document.por.src='Images/locatedown.jpg'"
onmouseout="document.por.src='Images/locateup.jpg'">
<img src="Images/locateup.jpg" border=0
name="por"></a> <br>
<a href="links.html" onmouseover="document.gue.src='Images/linksdown.jpg'"
onmouseout="document.gue.src='Images/linksup.jpg'">
<img src="Images/linksup.jpg" border=0
name="gue"></a> <br>
<a href="contact.html" onmouseover="document.ctc.src='Images/contactdown.jpg'"
onmouseout="document.ctc.src='Images/contactup.jpg'">
<img src="Images/contactup.jpg" border=0
name="ctc"></a> <br>
<img src="Images/bottom.jpg">
</td></tr></table>
<td><font size=+1>
<table width=60% border=0><tr><td><font size=+1>
Here at used<font color=red>OEM</font>parts.com we work for you. We are linked to thousands of
automotive salvage yards in the U.S as well as canada. When you submit your
parts request form you will be contacted via email or phone with the best
prices on the part you're searching for. this feature allows you to save
money and time, without the hassle of calling several salvage yards. Start
your search now</FONT>
</td></tr></table>
<table WIDTH="10%" BORDER="0" CELLSPACING="0" CELLPADDING="0"
HEIGHT="199" BACKGROUND="Images/formbg.jpg">
<tr VALIGN="top"><td>
<table WIDTH="400" BORDER="0" CELLSPACING="0" CELLPADDING="0"
HEIGHT="35" BACKGROUND="/images/design/transPixel.gif">
<tr><td> </td></tr></table>
<table WIDTH="400" BORDER="0" CELLSPACING="0" CELLPADDING="0" BACKGROUND="/images/design/transPixel.gif">
<tr><td HEIGHT="42"> </td>
<td HEIGHT="42" VALIGN="top">
<div ALIGN="left">
<form name=frm1>
<select NAME="year" onchange="this.form.submit()">
<?
if(isset($GET['year'])){
printf('<option value="'.$GET['year'] . '">'.$GET['year'] . '</option>');
}else{
printf('<option value="">Select Vehicle Year</option>');
}
?>
<option VALUE="2005">2005
<option VALUE="2004">2004
<option VALUE="2003">2003
<option VALUE="2002">2002
<option VALUE="2001">2001
<option VALUE="2000">2000
<option VALUE="1999">1999
<option VALUE="1998">1998
<option VALUE="1997">1997
<option VALUE="1996">1996
<option VALUE="1995">1995
<option VALUE="1994">1994
<option VALUE="1993">1993
<option VALUE="1992">1992
<option VALUE="1991">1991
<option VALUE="1990">1990
<option VALUE="1989">1989
<option VALUE="1988">1988
<option VALUE="1987">1987
<option VALUE="1986">1986
<option VALUE="1985">1985
<option VALUE="1984">1984
<option VALUE="1983">1983
<option VALUE="1982">1982
<option VALUE="1981">1981
<option VALUE="1980">1980
<option VALUE="1979">1979
<option VALUE="1978">1978
<option VALUE="1977">1977
<option VALUE="1976">1976
<option VALUE="1975">1975
<option VALUE="1974">1974
<option VALUE="1973">1973
<option VALUE="1972">1972
<option VALUE="1971">1971
<option VALUE="1970">1970
<option VALUE="1969">1969
<option VALUE="1968">1968
<option VALUE="1967">1967
<option VALUE="1966">1966
<option VALUE="1965">1965
<option VALUE="1964">1964
<option VALUE="1963">1963
<option VALUE="1962">1962
<option VALUE="1961">1961
<option VALUE="1960">1960
<option VALUE="1959">1959
<option VALUE="1958">1958
<option VALUE="1957">1957
<option VALUE="1956">1956
<option VALUE="1955">1955
<option VALUE="1954">1954
</select></form>
</div>
</td>
</tr>
<tr>
<td WIDTH="124" HEIGHT="48"> </td>
<td HEIGHT="48" VALIGN="top">
<div ALIGN="left">
<form name=frm2>
<select NAME="make" onchange="this.form.submit()">
<?php
if(isset($GET['make']))
{
printf('<option value="'.$GET['make'] . '">'.$GET['make'] . '</option>');
while ($result1 = mysql_fetch_array($query1))
{
printf('<option value="'.$result1['make'] . '">'.$result1['make'] . '</option>');
}
}else{
printf('<option value="">Select Vehicle Make</option>');
while ($result1 = mysql_fetch_array($query1))
{
printf('<option value="'.$result1['make'] . '">'.$result1['make'] . '</option>');
}
}
?>
</select></form>
</div>
</td>
</tr>
<tr>
<td WIDTH="124" HEIGHT="35"> </td>
<td HEIGHT="35" VALIGN="top">
<form name=frm3>
<select NAME="model" onchange="this.form.submit()">
<?php
if(isset($_GET['make']))
{
printf('<option value="">Select Vehicle Model</option>');
printf('<option value="'.$result1['m1'] . '">'.$result1['m1'] . '</option>');
printf('<option value="'.$result1['m1'] . '">'.$result1['m1'] . '</option>');
printf('<option value="'.$result1['m2'] . '">'.$result1['m2'] . '</option>');
printf('<option value="'.$result1['m3'] . '">'.$result1['m3'] . '</option>');
printf('<option value="'.$result1['m4'] . '">'.$result1['m4'] . '</option>');
printf('<option value="'.$result1['m5'] . '">'.$result1['m5'] . '</option>');
printf('<option value="'.$result1['m6'] . '">'.$result1['m6'] . '</option>');
printf('<option value="'.$result1['m7'] . '">'.$result1['m7'] . '</option>');
printf('<option value="'.$result1['m8'] . '">'.$result1['m8'] . '</option>');
printf('<option value="'.$result1['m9'] . '">'.$result1['m9'] . '</option>');
printf('<option value="'.$result1['m10'] . '">'.$result1['m10'] . '</option>');
printf('<option value="'.$result1['m11'] . '">'.$result1['m11'] . '</option>');
printf('<option value="'.$result1['m12'] . '">'.$result1['m12'] . '</option>');
printf('<option value="'.$result1['m13'] . '">'.$result1['m13'] . '</option>');
printf('<option value="'.$result1['m14'] . '">'.$result1['m14'] . '</option>');
printf('<option value="'.$result1['m15'] . '">'.$result1['m15'] . '</option>');
printf('<option value="'.$result1['m16'] . '">'.$result1['m16'] . '</option>');
printf('<option value="'.$result1['m17'] . '">'.$result1['m17'] . '</option>');
printf('<option value="'.$result1['m18'] . '">'.$result1['m18'] . '</option>');
printf('<option value="'.$result1['m19'] . '">'.$result1['m19'] . '</option>');
printf('<option value="'.$result1['m20'] . '">'.$result1['m20'] . '</option>');
printf('<option value="'.$result1['m21'] . '">'.$result1['m21'] . '</option>');
printf('<option value="'.$result1['m22'] . '">'.$result1['m22'] . '</option>');
printf('<option value="'.$result1['m23'] . '">'.$result1['m23'] . '</option>');
printf('<option value="'.$result1['m24'] . '">'.$result1['m24'] . '</option>');
printf('<option value="'.$result1['m25'] . '">'.$result1['m25'] . '</option>');
printf('<option value="'.$result1['m26'] . '">'.$result1['m26'] . '</option>');
printf('<option value="'.$result1['m27'] . '">'.$result1['m27'] . '</option>');
printf('<option value="'.$result1['m28'] . '">'.$result1['m28'] . '</option>');
printf('<option value="'.$result1['m29'] . '">'.$result1['m29'] . '</option>');
}else{
printf('<option value="">Select Vehicle Model</option>');
}
?>
</select>
</form>
</td>
</tr>
</table>
<table WIDTH="300" BORDER="0" CELLSPACING="0" CELLPADDING="0" ALIGN="center" HEIGHT="55" BACKGROUND="/images/design/transPixel.gif">
<tr>
<td>
<div ALIGN="center">
<input TYPE="image" SRC="Images/button.jpg" WIDTH="168" HEIGHT="41" BORDER="0">
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</TD>
</table>
</body>
</html>
Sorry to dump this on you, but this is really making me crazy and I dont know where to tturn, thanks.
the site's at www.lukesplace.com/jeff
