I cannot get this scrip to update my database. Please help
<?php
mysql_connect();
mysql_select_db();
$sql = "SELECT * FROM KEYCAD WHERE Hold LIKE 'N' ORDER BY ContactDate DESC";
$result = mysql_query($sql);
echo "<form method='post' action='submit.php'>\n";
while ($currentRow = mysql_fetch_array($result)) {
echo "<table border=2 bordercolor=#5E3964>\n";
echo "<tr>
<td><font color=#FF0000>Name</font></td>
<td><font color=#FF0000>Home #</font></td>
<td><font color=#FF0000>Work #</font></td>
<td><font color=#FF0000>Car Model</font></td>
</tr>\n";
printf("
<tr>
<input type='hidden' name='RO[]' value='%s'>
<td>%s</td>
<td>%s</td>
<td>%s</td>
<td>%s</td>
</tr>\n",
$currentRow["RO"],
$currentRow["CUSTOMERNAME"],
$currentRow["HOME-PHONE"],
$currentRow["BUS-PHONE"],
$currentRow["MODEL"]
);
echo "<tr>
<td><font color=#FF0000>Follow-Up Needed</font></td>
<td><font color=#FF0000>Customer Not Reached</font></td>
<td><font color=#FF0000>Fixed Correctly?</font></td>
<td><font color=#FF0000>Treatment?</font></td>
</tr>\n";
printf("
<tr>
<td><input type=text name='Follow-UpContact[]' value='%s'></td>
<td><input type=text name='CustomerNotReached[]' value='%s'></td>
<td><input type=text name='Q1[]' value='%s'></td>
<td><input type=text name='Q2[]' value='%s'></td>
</tr>\n",
$currentRow["Follow-UpContact"],
$currentRow["CustomerNotReached"],
$currentRow["Q1"],
$currentRow["Q2"]
);
echo "<tr>
<td><font color=#FF0000>Clear Explanation?</font></td>
<td><font color=#FF0000>Overall Service?</font></td>
<td><font color=#FF0000>Why Not Fixed?</font></td>
<td><font color=#FF0000>Labor Code</font></td>
</tr>\n";
printf("
<tr>
<td><input type=text name='Q3[]' value='%s'></td>
<td><input type=text name='Q4[]' value='%s'></td>
<td><input type=text name='Q5[]' value='%s'></td>
<td><input type=text name='LaborCode[]' value='%s'></td>
</tr>\n",
$currentRow["Q3"],
$currentRow["Q4"],
$currentRow["Q5"],
$currentRow["LaborCode"]
);
echo "<tr>
<td><font color=#FF0000>Comments</font></td>
<td><font color=#FF0000>Happy</font></td>
<td><font color=#FF0000>Close Date</font></td>
<td></td>
</tr>\n";
printf("
<tr>
<td><input type=text name='Comments[]' value='%s'></td>
<td><input type=text name='HAPPY[]' value='%s'></td>
<td>%s</td>
<td><input type=Submit name=submit value=Submit></td>
</tr>
</form></table>\n",
$currentRow["Comments"],
$currentRow["HAPPY"],
$currentRow["CLOSE-DATE"]
);
}
?>
And Here is the submit.php
<?php
$RO= $HTTP_POST_VARS['RO'];
$CUSTOMERNAME = $HTTP_POST_VARS['CUSTOMERNAME'];
$HOME-PHONE = $HTTP_POST_VARS['HOME-PHONE'];
$BUS-PHONE = $HTTP_POST_VARS['BUS-PHONE'];
$MODEL = $HTTP_POST_VARS['MODEL'];
$Follow-UpContact = $HTTP_POST_VARS['Follow-UpContact'];
$CustomerNotReached = $HTTP_POST_VARS['CustomerNotReached'];
$Q1 = $HTTP_POST_VARS['Q1'];
$Q2 = $HTTP_POST_VARS['Q2'];
$Q3 = $HTTP_POST_VARS['Q3'];
$Q4 = $HTTP_POST_VARS['Q4'];
$Q5 = $HTTP_POST_VARS['Q5'];
$LaborCode = $HTTP_POST_VARS['LaborCode'];
$Comments = $HTTP_POST_VARS['Comments'];
$HAPPY = $HTTP_POST_VARS['HAPPY'];
$CLOSE-DATE = $HTTP_POST_VARS['CLOSE-DATE'];
mysql_connect();
mysql_select_db();
$query = mysql_query("SELECT * FROM KEYCAD WHERE RO='$RO'");
$row = mysql_fetch_array($query);
if (mysql_num_rows($query) == '0') {
$query2 = mysql_query("INSERT INTO KEYCAD (CUSTOMERNAME, HOME-PHONE, BUS-PHONE, MODEL, Follow-UpContact, CustomerNotReached, Q1, Q2, Q3, Q4, Q5, LaborCode, Comments, HAPPY, CLOSE-DATE) VALUES ('$CUSTOMER NAME', '$HOME-PHONE', '$BUS-PHONE', '$MODEL', '$Follow-UpContact', '$CustomerNotReached', '$Q1', '$Q2', '$Q3', '$Q4', '$Q5', '$LaborCode', '$Comments', '$HAPPY', '$CLOSE-DATE')");
} else {
// this is assuming you have an id field
$query2 = mysql_query("UPDATE KEYCAD SET CUSTOMERNAME='$CUSTOMERNAME', HOME-PHONE='$HOME-PHONE', BUS-PHONE='$BUS-PHONE', MODEL='$MODEL', Follow-UpContact='$Follow-UpContact', CustomerNotReached='$CustomerNotReached', Q1='$Q1', Q2='$Q2', Q3='$Q3', Q4='$Q4', Q5='$Q5', LaborCode='$LaborCode', Comments='$Comments', HAPPY='$HAPPY', CLOSE-DATE='$CLOSE-DATE' WHERE RO='" . $row["RO"] . "'");
}
?>
Thanks in advance for any help.
