Okay, well I echoed my variables before the update query and none of them return, including the $id. So I'm assuming it has something to do with the id or I'm not using the correct syntax for variable names in the update query (but it looks fine to me). For reference I also included the referring code that links to this modify screen.
[B]The Referring script with URL to modify area[/B]
<?
while(list($id,$date,$username,$title,$dreamstatus,$entry,$awareness,$pagination) = mysql_fetch_row($result)){
$d = explode("-",$date);
$titletrimmed = substr($title, 0, 30);
$thedate = "$d[2]/$d[1]/$d[0]";
$print = "\n<tr class=\"cells\">\n";
$print .= "<td><li>$date</td><td><b><a href=\"home.php?page=manage&action=modify&entry=$id\">$titletrimmed...</a></b></td>\n";
$print .= "<td>$dreamstatus</td>";
$print .= "<td>$awareness</td>";
$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=modify&entry=$id\">";
$print .= "Modify</a></td>\n";
$print .= "<td align=\"center\"><a href=\"home.php?page=manage&action=remove&entry=$id\">";
$print .= "Delete</a></td>\n";
$print .= "</tr>\n";
echo $print;
?>
[B]The Modify Script[/B]
<?
if(isset($_POST['submit'])){
echo "id: ".$id."<BR/>";
echo "Date: ".$date."<BR/>";
echo "Title: ".$title."<BR/>";
echo "Username: ".$username."<BR/>";
echo "Entry: ".$entry."<BR/>";
$id = $_GET['$id'];
$news1 = nl2br($news1);
$newsfull1 = nl2br($newsfull1);
$query = "UPDATE entries set date='$date', username='$username', title='$title', dreamstatus='$dreamstatus', entry='$entry', awareness='$awareness', pagination='$pagination' WHERE id='$id'";
mysql_query($query,$db);
echo"<center>Post with article " . $id . " has been modified!$b</center>";
} else {
$query = mysql_query("Select * from $table where id='$id' order by date");
while(list($id, $date, $username, $title, $dreamstatus, $entry, $awareness, $pagination) = mysql_fetch_row($query)) {
?>
</div>
<div align="center">
<center>
<table width="95%" border="0" cellpadding="3" cellspacing="1" class="table_border">
<tr>
<form method="POST" action="<? echo "home.php?page=manage&action=modify&entry=$id";?>">
<td colspan="2" class="header_cell"> <p align="center">Modify an Existing
Journal Entry</p></td>
</tr>
<tr>
<td width="23%" align="right" class="cells">Date:</td>
<td width="77%" class="cells"><input class="box" type="text" name="date" size="30" value="<?=$date;?>"></td>
<? $username = $_SESSION['username'];?>
<input name="username" type="hidden" value="<? echo $username; ?>">
</tr>
<tr>
<td align="right" class="cells">Dream Title:</td>
<td class="cells"><input class="box" type="text" name="title" size="30" value="<?=$title;?>"></td>
</tr>
<tr>
<td align="right" class="cells">Recent or Past Dream?</td>
<td class="cells">Recent
<? if ($dreamstatus == "recent") {
print "<input name=\"dreamstatus\" type=\"radio\" value=\"Past\" checked>
Past
<input type=\"radio\" name=\"dreamstatus\" value=\"Recent\">";
}
else {
print "<input name=\"dreamstatus\" type=\"radio\" value=\"Past\">
Past
<input type=\"radio\" name=\"dreamstatus\" value=\"Recent\" checked>";
}
?>
</td>
</tr>
<tr>
<td align="right" valign="top" class="cells">Dream Entry</td>
<td class="cells"><textarea name="entry" cols="80" rows="15" wrap="PHYSICAL" class="input"><? echo $entry; ?></textarea>
</textarea></td>
</tr>
<tr>
<td align="right" valign="top" class="cells">Level of Awareness:</td>
<td class="cells"><select name="select" id="select">
<option selected>Select Level</option>
<option value="Low">Low</option>
<option value="Medium">Medium</option>
<option value="High">High</option>
</select></td>
</tr>
<tr>
<td align="right" valign="top" class="cells"> </td>
<td class="cells"><input name="submit" type="submit" class="tablecell2" id="submit" value="Modify My Dream"></td>
</tr>
<tr>
<td colspan="2" class="header_cell"> <p align="center"> </td></form>
</tr>
</table>
</center>
</div>
<?
}
}
}
?>
