- //php stuff
-
-
if($submit) {
-
$sql = "SELECT * FROM Release ORDER BY Release";
-
$result = mysql_query($sql, $db);
-
if($result) {
-
echo '<pre>';
-
print_r($_POST);
-
echo '</pre>';
-
-
while($myrow = mysql_fetch_array($result)) {
-
$name = $myrow["Release"] . "_search_string";
-
$dateCode_name = $myrow["Release"] . "_valid_dateCodes";
-
-
$myvar = $myrow["Release"];
-
-
$sql = "REPLACE INTO Release (Release, Supported, search_string,valid_dateCodes) VALUES ('$myvar', '$_POST[$myvar]', '$_POST[$name]', '$_POST[$dateCode_name]')";
-
}
-
-
//and relevant html code
-
-
<FORM ACTION="release.php3?ma=patchguard&sa=editRelease" method="POST">
-
<TABLE>
-
<TR><TH>Release</TH><TH>Supported?</TH></TR>
-
<TR><TD COLSPAN="2"><HR NOSHADE></TD></TR>
-
<?
-
$sql = "SELECT * FROM Release ORDER BY Release";
-
$result = mysql_query($sql, $db);
-
if($result) {
-
while($myrow = mysql_fetch_array($result)) {
-
-
$myvar = $myrow["Release"];
-
-
$s_value = $myrow["search_string"];
-
-
$name = $myvar . "_search_string";
-
-
$search_text = " <input type='text' name='$name' size='8' value='$s_value'>";
-
-
$s_value = $myrow["valid_dateCodes"];
-
-
$dateCode_name = $myvar . "_valid_dateCodes";
-
-
$valid_dateCodes = " <input type='text' name='$dateCode_name' size='25' value='$s_value'>";
-
-
$myrelease = $myrow["Supported"];
-
-
$output = "<TR><TD>" . $myvar . "</TD><TD>No longer supported<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='noLongerSupported'";
-
-
if($myrow["Supported"] == "noLongerSupported") {
-
$outputplus = " CHECKED> Supported<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='supported'> Future<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='future'>$search_text $valid_dateCodes</TD></TR>";
-
echo($output . $outputplus);
-
}
-
else if($myrow["Supported"] == "supported") {
-
$outputplus = "> Supported<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='supported' CHECKED> Future<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='future'>$search_text $valid_dateCodes</TD></TR>";
-
echo($output . $outputplus);
-
}
-
else if($myrow["Supported"] == "future") {
-
$outputplus = "> Supported<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='supported'> Future<INPUT TYPE='radio' NAME='" . $myvar . "' VALUE='future' CHECKED>$search_text $valid_dateCodes</TD></TR>";
-
echo($output . $outputplus);
-
}
-
else {
-
echo ("Error outputing $myvar information");
-
}
-
}
-
}
-
?>
-
<TR><TD COLSPAN="2"><HR NOSHADE></TD></TR>
-
<TR><TD><INPUT TYPE="text" NAME="Release"></TD><TD>No longer supported<INPUT TYPE='radio' NAME='Supported' VALUE='noLongerSupported'> Supported<INPUT TYPE='radio' NAME='Supported' VALUE='supported' checked> Future<INPUT TYPE='radio' NAME='Supported' VALUE='future'></T</TD></TR>
-
<TR><TD COLSPAN="2"><CENTER><INPUT TYPE="submit" NAME="submit" VALUE="Submit"></CENTER></TD></TR>
-
</TABLE>
-
</FORM>
When I enter a new "Release" with a "." in it, it works fine at first, but when I make changes to any release it replaces the "." with a "_".
ie. Test.1 becomes Test_1 as shown when I print out the _POST vars, so then when it tries to replace each entry in the DB it cannot find Test_1_search_string and the REPLACE is aborted.
Here is the _POST info for the "Release" that was named "Test.1"
[Test_1] => supported
[Test_1_search_string] =>
[Test_1_valid_dateCodes] =>
Did that make sense????