[SOLVED] An update query that doesn't update.

[Flames]

this is the part that of the code that uses an update, be warned if you require the whole code, its around 500 lines.

$date = date("Y-m-d");
$update_sql = "UPDATE News SET name='{$_POST['edit_form_title']}', message='{$_POST['edit_form_message']}', message2='{$_POST['edit_form_long_message']}',
poster='{$_POST['edit_form_poster']}', date='{$_POST['edit_form_date']}', edit_date='$date' WHERE id='$id'";
mysql_query($update_sql) or die(mysql_error());
/* if(!$update_query)
{
echo "Error doing your edit";
}
else
{
echo "The news topic " . $id . " was edited successfully. <br /> go back to the <a class=\"link1\" href=\"edit_news.php\">edit news page</a>";
}*/

note the part thats commented out, because before $update_query was the mysql_query. im not getting any errors just its not updating.

[AndyB]

Why don't you echo $update_sql and see what the actual query is?  Chance are, it'll be self-evident why it's not doing what you expect.

[Flames]

fixed my stupid mistake, trying to call upon a variable that hadn't been set in that instance. the answer came from your suggestion so thans.