Cants seem to update

[phpDumbo]

Im tryin to update a table in a database and my code is not worknig and i cant for the life of me figure out what is wrong with it. Please help thanks

if($_POST["submit"])
{

	$headline = $_POST["headlineUpdate"];
	$body = $_POST["bodyUpdate"];
	$date = $_POST["dateUpdate"];
	$staffid = $_POST["staffidUpdate"];

	mysql_query("UPDATE Articles SET headline = '$headline body' = '$body'  date = '$date'
					staffid = '$staffid'  WHERE id = '" . $_GET["id"] . "'") or mysql_error();
}

if($_GET["id"])
{

	$article = mysql_fetch_array(mysql_query("SELECT * FROM Articles WHERE id = '" . $_GET["id"] . "' "));

	$articleid = $article["ID"];
	$headline = $article["headline"];
	$body = $article["body"];
	$date = $article["date"];
	$staffid = $article["staffid"];

	echo "<a href=\"index.php\">Back to List</a>";

	?>
	<form>
		<p>Headline : <input type = "text" name = "headlineUpdate" value = "<?php echo $headline; ?>" /></p>
		<p>Body : <textarea name = "bodyUpdate" cols = "50" rows = "20"  ><?php echo $body; ?></textarea></p>
		<p>Date : <input type = "text" name = "dateUpdate" value = "<?php echo $date; ?>" /></p>
		<p>StaffID : <input type = "text" name = "staffidUpdate" value = "<?php echo $staffid; ?>" /></p>
		<p><input type="submit" name ="submit" value = "Update" /></p>
	</form>	
	<?php
}else{

?>


	<form>
		<input type="button" onClick="window.location='index.php'" value="main menu" />
	</form>

	<h4>List of Articles</h4>


	<?php echo $listofarticles; ?>

<?php } ?>

one problem i come to notice its not even getting to this point to execute it

$headline = $POST["headlineUpdate"];
$body = $POST["bodyUpdate"];
$date = $POST["dateUpdate"];
$staffid = $POST["staffidUpdate"];

	mysql_query("UPDATE Articles SET headline = '$headline body' = '$body'  date = '$date'
					staffid = '$staffid'  WHERE id = '" . $_GET["id"] . "'") or mysql_error();

[Trs2988]

One thing I notice is that your query format is wrong. I don't know if it's the only problem (because you said it wasn't even getting that far), but it is a problem.

mysql_query("UPDATE Articles SET headline = '$headline body' = '$body' date = '$date' staffid = '$staffid' WHERE id = '" . $_GET["id"] . "'") or mysql_error();

Specifically, this part:

SET headline = '$headline body' = '$body' date = '$date' staffid = '$staffid'

It should be:

mysql_query("UPDATE Articles SET headline='$headline',body='$body',date='$date, staffid = '$staffid' WHERE id = '" . $_GET["id"] . "'") or mysql_error();

Also notice that if the headling or body has single quotes in them, it won't work. You'll probably want to use mysql_real_escape_string or something like that.