I'm using the code down below to update a database thru a form. The contents are pulled from the databse thru ID which is passed to this page from another using GET function. The form displays all the necessary content but when i attempt to edit it thru the form nothing happens. Just wondering if someone can spot the mistake?
[PHP]<?php include("dbconnect.php")
if(isset($_GET))
{
$query = "SELECT * FROM mynews WHERE id = '{$_GET}'";
if (!isset($_POST["submit"])) //if submit has not yet been pressed, do this
{
$id = $_GET["id"]; //get the id of the news article being edited. This is provided in the link to edit it.
$sql = "SELECT * FROM mynews WHERE id='$id'"; //select all columns from mynews with this id
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
if ($_POST)
{
$title = $_POST;
$message = $_POST;
$user = $_POST;
$sql = "UPDATE mynews SET title='$title', message='$message', user='$user', link='$link', rss='$rss', keyword='$keyword' WHERE id='$id'";
$result = mysql_query($sql); //run this query
echo "Information updated. <a href=test2.php>Return</a>";
}
?>
<form action="editcontent.php" method="post">
<table width="400" border="0">
<tr>
<td width="109">News Title </td>
<td width="281"><INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["title"] ?>" SIZE=30></td>
</tr>
</table>
</form>
<?
}
}
?>
[/PHP]
The form has more than one field but i took them out because its just duplicating code.
