Simple SQL problem

[furious5]

Can anyone help me out, I seem to have an SQL statement that just doesn't want to work.

I'm trying to do a really simple update and I keep getting a query is empty error, if I run the query through phpmyadmin no rows are affected even though I know there is a record for the matching id.

Don't you just love coming back off holiday.

UPDATE weekly_offers SET Week_Commencing='2004-06-05', Days='7', Old_Price='995', Price='595 inc car' WHERE ID=289

[freebie]

try this using PHP

//.. dbconn code here
echo "Verifying Row exists ". mysql_num_rows(mysql_query("Select * from weekly_offers where ID=289")) . "<br>";
$SQL="UPDATE weekly_offers SET Week_Commencing='2004-06-05', Days='7', Old_Price='995', Price='595 inc car' WHERE ID=289";
if(mysql_query($SQL)){
   echo "successful";
}else{
   echo mysql_error();
}