whats wrong with my update query it resets date to 0000/00/00

[lisa007]

hi i'm trying to update my data from my database but it keeps reset the date back to 0000/00/00

and now it says error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' DATE_FORMAT(new s_date, '%Y/%m/%d') as new_date FROM news SET new_date='', subj' at line 1

this what i got help please

$query = "UPDATE, DATE_FORMAT(news_date, '%Y/%m/%d') as new_date FROM news SET new_date='$new_date',  subject='$subject', news_artical='$news_artical' WHERE news_id = '$news_id'";

[code green]

UPDATE syntax is

UPDATE tablename SET field = newvalue

[lisa007]

if u mean like this it sets the date back into 0000/00/00

 $query = "UPDATE news SET news_date='$news_date', subject='$subject', news_artical='$news_artical' WHERE news_id = '$news_id'";

[code green]

Check the value of $news_date

[Canabeez]

I would also suggest to always use addslashes()