What doesnt this UPDATE query work in PHP? (SPOT THE ERRORS)?

Question

I think theres an error somewhere in this script, but im quite good with PHP and i can't spot any? Bascially this script updates peoples pictures on my server. Ive had update querys work before but this doesnt work.

DO YOU SEE ANY POSSIBLE ERRORS OR WHY THIS MAY NOT BE WORKING? List as many as you can think of please.

if ($PASSWORD == $_POST['MYPASSWORD2'])
{
$file_name = $_FILES['ufile']['name'];
$random_digit=rand(0000,9999);
$new_file_name=$random_digit.$file_name;
$path= "/Uploads/".$new_file_name;
if($ufile !=none)
{
if(copy($_FILES['ufile']['tmp_name'], $path))
{
$_SESSION['op']=$new_file_name;
}
}
$query = "UPDATE table SET SITENAMEIMG1='hi'
WHERE USERNAME=\"" . $_SESSION['USERNAME'] . "\" AND PASSWORD=\"" . $_POST['MYPASSWORD2'] . "\"";
$result = mysql_query($query)
or die("oh no");
header("location:/Main/Picture Updated.php");
exit();

Answer 1

Try changing your field Password to something like pass. Password is a key word in SQL and therefore your update statement will not work. Give it a try and let me know if it works.

Hope this helps

Answer 2

what is the error message being returned?

Answer 3

I dont see any either! Sorry!