ah, it's still not working. i'm just going to show you all of my code, from the beginning of the process to the end. maybe there's something i'm missing in the javascript...since i'm not too familiar with it.
connect.php
<?php
include 'misc.inc';
/* connect to server(mysql) with pconnect for persistent
connection, not to close then reconnect */
mysql_pconnect("$host","$user","$password")
or die ("Couldn't connect to the server.");
/* connect to db (bandvans) */
mysql_select_db("bandvans")
or die ("Couldn't connect to the database.");
?>
drop.php
<?php include 'head.asp'; ?>
<script type="text/javascript">
<!--
function select1(selected)
{
newBox = document.forms.mm.model
for (var i=0; i<newBox.options.length; i++)
{
newBox.options[i]=null;
}
if (selected=="chevrolet")
{
x=new Array("Astro","Express","Venture","Chevy Van 2500","Chevy Express 3500","Sport Van 20","Chevy Van 20","Beauville 20")
}
else if (selected=="chrysler")
{
x=new Array("Town & Country","Voyager")
}
else if (selected=="dodge")
{
x=new Array("Caravan","Grand Caravan","Ram 350","Ram 3500","Ram 15 Passenger","Ram 250 Custom","Dodge Van 200","Tradesman 100")
}
else if (selected=="ford")
{
x=new Array("Club Wagon","Club Wagon XLT","Club Wagon Chateau","Super Van","E-150","E-250","E-300","E-350","Freestar","Windstar")
}
else if (selected=="gmc")
{
x=new Array("Safari","Safari XT","Savana")
}
else if (selected=="honda")
{
x=new Array("Odyssey")
}
else if (selected=="isuzu")
{
x=new Array("Ascender")
}
else if (selected=="kia")
{
x=new Array("Sedona")
}
else if (selected=="mazda")
{
x=new Array("MPV")
}
else if (selected=="mercury")
{
x=new Array("Monterey")
}
else if (selected=="nissan")
{
x=new Array("Quest")
}
else if (selected=="oldsmobile")
{
x=new Array("Silhouette")
}
else if (selected=="pontiac")
{
x=new Array("Montana")
}
else if (selected=="saturn")
{
x=new Array("Vue")
}
else if (selected=="scion")
{
x=new Array("xB")
}
else if (selected=="toyota")
{
x=new Array("Sienna")
}
else if (selected=="vw")
{
x=new Array("Eurovan","Vanagon L","Vanagon GL","Vanagon Carat")
}
for (i=0; i<x.length; i++)
{
newBox.options[i] = new Option(x[i])
}
}
//-->
</script>
<form name="mm" form action="insertMakeModel.php" method="post">
Choose a Make & Model:
<select name="make" onchange="select1(this.options[selectedIndex].value)">
<option value="chevrolet">Chevrolet</option>
<option value="chrysler">Chrysler</option>
<option value="dodge">Dodge</option>
<option value="ford">Ford</option>
<option value="gmc">GMC</option>
<option value="honda">Honda</option>
<option value="isuzu">Isuzu</option>
<option value="kia">Kia</option>
<option value="mazda">Mazda</option>
<option value="mercury">Mercury</option>
<option value="nissan">Nissan</option>
<option value="oldsmobile">Oldsmobile</option>
<option value="pontiac">Pontiac</option>
<option value="saturn">Saturn</option>
<option value="scion">Scion</option>
<option value="toyota">Toyota</option>
<option value="vw">Volkswagen</option>
</select>
<select name="model">
<option value="astro">Astro</option>
<option value="express">Express</option>
<option value="venture">Venture</option>
</select>
<input type="submit" class="button" value="Input that shit!">
</form>
<?php include 'footer.asp'; ?>
insertMakeModel.php
<?php
include 'misc.inc';
include 'head.asp';
include 'connect.php';
if($_POST['mm'] != "")
{
$query = "INSERT into Test (make,model) VALUES('".$_POST['make']."','".$_POST['model']."'";
$result = mysql_query($query)
or die (mysql_error());
}
include 'footer.asp';
?>
that's what i got. i also tried posting the variables to the 'insertMakeModel.php' page by using:
$make = $HTTP_POST_VARS['make'];
but that didn't seem to make a difference either! i can't believe i'm stuck on inputting data into the db!!
diego, thank you so much for your help thus far, and you too weedpacket!!
