I am not a programmer, I'm a band director, but I got roped into writing a web registration form for my district 7th grade honor band. I have everything working properly except for one section that will not save properly to the database. I need to write each entry to the DB. If there was a way to prevent it from saving any rows that were blank that would be great but I can live with blank rows in the DB if it winds up being an easy fix.
This is the relevant part of the form:
<table>
<tr>
<td>Priority</td><td>First Name </td><td>Last Name</td><td>Instrument</td> </tr>
<tr>
<td> <input type="text" name="priority1" /></td><td><input type="text" name="first1" /></td><td><input type="text" name="last1" /></td><td>Flute<input type="hidden" value="Flute" name="instrument1"></td></tr>
<td> <input type="text" name="priority2" /></td><td><input type="text" name="first2" /></td><td><input type="text" name="last2" /></td><td>Flute<input type="hidden" value="Flute" name="instrument2"></td></tr>
<td> <input type="text" name="priority3" /></td><td><input type="text" name="first3" /></td><td><input type="text" name="last3" /></td><td>Oboe<input type="hidden" value="Oboe" name="instrument3"></td></tr>
<td> <input type="text" name="priority4" /></td><td><input type="text" name="first4" /></td><td><input type="text" name="last4" /></td><td>Bassoon<input type="hidden" value="Bassoon" name="instrument4"></td></tr>
<td> <input type="text" name="priority5" /></td><td><input type="text" name="first5" /></td><td><input type="text" name="last5" /></td><td>Clarinet<input type="hidden" value="Clarinet" name="instrument5"></td></tr>
<td> <input type="text" name="priority6" /></td><td><input type="text" name="first6" /></td><td><input type="text" name="last6" /></td><td>Clarinet<input type="hidden" value="Clarinet" name="instrument6"></td></tr>
<td> <input type="text" name="priority7" /></td><td><input type="text" name="first7" /></td><td><input type="text" name="last7" /></td><td>Low Clarinet<input type="hidden" value="Low Clarinet" name="instrument7"></td></tr>
<td> <input type="text" name="priority8" /></td><td><input type="text" name="first8" /></td><td><input type="text" name="last8" /></td><td>Alto Sax<input type="hidden" value="Alto Sax" name="instrument8"></td></tr>
<td> <input type="text" name="priority9" /></td><td><input type="text" name="first9" /></td><td><input type="text" name="last9" /></td><td>Tenor Sax<input type="hidden" value="Tenor Sax" name="instrument9"></td></tr>
<td> <input type="text" name="priority10" /></td><td><input type="text" name="first10" /></td><td><input type="text" name="last10" /></td><td>Bari Sax<input type="hidden" value="Bari Sax" name="instrument10"></td></tr>
<td> <input type="text" name="priority11" /></td><td><input type="text" name="first11" /></td><td><input type="text" name="last11" /></td><td>Trumpet<input type="hidden" value="Trumpet" name="instrument11"></td></tr>
<td> <input type="text" name="priority12" /></td><td><input type="text" name="first12" /></td><td><input type="text" name="last12" /></td><td>Trumpet<input type="hidden" value="Trumpet" name="instrument12"></td></tr>
<td> <input type="text" name="priority13" /></td><td><input type="text" name="first13" /></td><td><input type="text" name="last13" /></td><td>Horn<input type="hidden" value="Horn" name="instrument13"></td></tr>
<td> <input type="text" name="priority14" /></td><td><input type="text" name="first14" /></td><td><input type="text" name="last14" /></td><td>Horn<input type="hidden" value="Horn" name="instrument14"></td></tr>
<td> <input type="text" name="priority15" /></td><td><input type="text" name="first15" /></td><td><input type="text" name="last15" /></td><td>Trombone<input type="hidden" value="Trombone" name="instrument15"></td></tr>
<td> <input type="text" name="priority16" /></td><td><input type="text" name="first16" /></td><td><input type="text" name="last16" /></td><td>Trombone<input type="hidden" value="Trombone" name="instrument16"></td></tr>
<td> <input type="text" name="priority17" /></td><td><input type="text" name="first17" /></td><td><input type="text" name="last17" /></td><td><SELECT name="instrument17" size="1"><option selected>Baritone B.C. <option>Baritone T.C.</SELECT> </td></tr>
<td> <input type="text" name="priority18" /></td><td><input type="text" name="first18" /></td><td><input type="text" name="last18" /></td><td>Tuba<input type="hidden" value="Tuba" name="instrument18"></td></tr>
<td> <input type="text" name="priority19" /></td><td><input type="text" name="first19" /></td><td><input type="text" name="last19" /></td><td><SELECT name="instrument19" size="1"><option selected>Percussion- Mallets<option>Percussion- No Mallets</SELECT></td></tr>
<td> <input type="text" name="priority20" /></td><td><input type="text" name="first20" /></td><td><input type="text" name="last20" /></td><td><SELECT name="instrument20" size="1"><option selected>Percussion- Mallets<option>Percussion- No Mallets</SELECT></td></tr>
</table>
This is the portion of the script that should save that data to the appropriate table in the DB:
$y=0;
do
{ $y++;
IF (isset($_POST["priority$y"])){
$query4 = "INSERT INTO 7hbSubmissions (priority, first, last, instrument, school) VALUES ('".$_POST["priority$y"]."','".$_POST["first$y"]."','".$_POST["last$y"]."','".$_POST["instrument$y"]."','".$_POST["school"]."')";
mysql_query($query4)or die("Couldn't save query4: ".mysql_error());
}
}
while($i<20);
I know that the DB is connecting properly because the other parts of the script save their pieces of data with no problem.Any help or advice would be appreciated. Thank you!
-MaestroC
