<table width="75%" align="center" valign="top">
<tr>
<td>
<form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" medthod="post">
<input type="hidden" name="dir" value="home">
<input type="hidden" name="page" value="newsarchive.html">
Month: <select name="month">
<option label="Select" value=""></option>
<option label="January" value="January"></option>
<option label="Febuary" value="Febuary"></option>
<option label="March" value="March"></option>
<option label="April" value="April"></option>
<option label="May" value="May"></option>
<option label="June" value="June"></option>
<option label="July" value="July"></option>
<option label="August" value="August"></option>
<option label="September" value="September"></option>
<option label="October" value="October"></option>
<option label="November" value="November"></option>
<option label="December" value="December"></option>
</select>
Year: <input type="text" name="year" size="4" maxlength="4">
<input type="submit" name="Go" value="Go">
</form><br><br>
</td>
</tr>
<?php
if (!isset($month) && !isset($year)) {
$month = date("F");
$year = date("Y");
}
$sql_sel = "select * from news where news_month='$month' and news_year='$year' order by news_day desc";
$sql_result_sel = mysql_query($sql_sel, $connection);
while ($row = mysql_fetch_array($sql_result_sel)) {
$news_title = $row["news_title"];
$news_editor = $row["news_editor"];
$news_data = $row["news_data"];
$news_month = $row["news_month"];
$news_day = $row["news_day"];
$news_year = $row["news_year"];
echo "
<tr>
<td>
<b>".$news_title."</b>
</td>
<td align=right>
<b>By ".$news_editor."</b>
</td>
</tr>
<tr>
<td colspan=2 valign=top>
".$news_data."
</td>
</tr>
<tr>
<td colspan=2 align=right><b>".$news_month." ".$news_day.", ".$news_year."</b><br><hr width=5% align=center></td>
</tr>
";
}
echo "
</table>
";
?>
The code above works it displays the varibals in the url bar.
<?php
if (isset($form_approval)) {
$sql_upd = "update comments set approval = '$form_approval' where name = '$form_name' and email = '$form_email' and comment = '$form_comment'";
$sql_result_upd = mysql_query($sql_upd, $connection);
}
$sql_sel = "select * from comments where approval='tba'";
$sql_result_sel = mysql_query($sql_sel, $connection);
echo "
<table width=75% align=center valign=top>
";
while ($row = mysql_fetch_array($sql_result_sel)) {
$name = $row["name"];
$email = $row["email"];
$comment = $row["comments"];
$approval = $row["approval"];
echo "
<form action=".$HTTP_SERVER_VARS['PHP_SELF']." method=get>
<tr>
<td>
<b>By ".$name."</b>
<input type=hidden name=form_name value=".$name.">
</td>
<td align=right>
<b>Email: ".$email."</b>
<input type=hidden name=form_email value=".$email.">
</td>
<td colspan=2 valign=top>
".$aprroval." change to
<select name=form_approval>
<option label=TBA value=tba selected></option>
<option label=Yes value=Yes></option>
<option label=No value=no></option>
</select>
</td>
</tr>
<tr>
<td colspan=3 valign=top>
".$comment."
<input type=hidden name=form_comment value=".$comment.">
</td>
</tr>
<tr>
<td colspan=3 valign=top>
<input type=submit name=Change value=Change>
</td>
</tr>
</form>
";
}
echo "
</table>
";
?>
this code doesn't display the varibaales in the url.