I am trying to submit the following form data to a My SQL database, I have it sent to submit to an email in this example.
1. How do I do I submit it to a My SQL database.
2. I am having trouble getting the js stuff to submit even to my email
Any help would be greatly appreciated.
<html>
<head>
<title>Planting</title>
<h><b><font size="5">Lippy Brothers Inc. Planting Record</font></b> </h><br /><br />
<SCRIPT LANGUAGE="JavaScript" SRC="CalendarPopup.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript">
var cal = new CalendarPopup();
</SCRIPT>
</head>
<body>
<form name="planting" method="post" action="mailto:adam@lippybrothersinc.com">
<b>Date:</b>
<INPUT TYPE="text" NAME="date" VALUE="" SIZE=25>
<A HREF="#"
onClick="cal.select(document.forms['planting'].date1,'anchor1','MM/dd/yyyy'); return false;"
NAME="anchor1" ID="anchor1">select</A><br /><br />
<b>Employee:</b>
<select name="employee">
<option value="Wes">Wes</option>
<option value="Adam">Adam</option>
<option value="Marshall">Marshall</option></select><br /><br />
<b>Farm:</b>
<select name="farm" >
<option value="Bauerlein">Bauerlein</option>
<option value="Boog">Boog</option>
<option value="Boring">Boring</option></select><br /><br />
<b>Crop:</b><br />
<script type="text/javascript">
function change(arr) {
var el = document.getElementById('variety');
el.options.length = 0;
for(var i = 0; i< arr.length; i++ ) {
el.options[el.options.length] = new Option( arr[i], arr[i]);
}
}
</script>
<label for="r0">Corn </label><input type="radio" name="rad" id="r0" onclick='change(["P35F44", "DK6544", "P33N58"]) '><br />
<label for="r1">Soybeans </label><input type="radio" name="rad" id="r1" onclick='change(["AG3905", "AG2802", "P93M61"]) '><br />
<label for="r2">Wheat </label><input type="radio" name="rad" id="r2" onclick='change(["P25R56", "P25R39", "P25R78"]) '><br />
<label for="r3">Barley </label><input type="radio" name="rad" id="r3" onclick='change(["Thoroughbred", "Price", "Barsoy"]) '><br />
<label for="r4">Snapbeans </label><input type="radio" name="rad" id="r4" onclick='change(["Titan", "Envy", "Labrador"]) '><br /><br />
<b>Variety:</b><br />
<select id="variety"></select><br /><br />
<b>Seeding Rate:</b>
<INPUT TYPE="text" NAME="seedingrate" VALUE="" SIZE=5><br /><br />
<b>Units:</b><br />
lbs/acre:<input type="radio" value="lbs" name="units">
plants/acre:<input type="radio" value="plants" name="units"><br /><br />
<b>Field Conditions:</b><br />
Excessively Wet:<input type="radio" value="excessively wet" name="fc">
Wet:<input type="radio" value="wet" name="fc">
Optimum:<input type="radio" value="optimumt" name="fc">
Dry:<input type="radio" value="dry" name="fc">
Excessively Dry:<input type="radio" value="excessively dry" name="fc"><br /><br />
<b>Total Planter Acreage:</b>
<INPUT TYPE="text" NAME="tpacre" VALUE="" SIZE=5><br /><br />
<b>Total Map Acreage:</b>
<INPUT TYPE="text" NAME="tmacre" VALUE="" SIZE=5><br /><br />
<b>Comments:</b><br />
<textarea rows="5" cols="20" wrap="physical" name="comments">
</textarea><br /><br />
<input type="submit" value="Email"><br /><br />
</form>
</body>
</html>