Need help with a MySQL update statement

[mapexdrum]

Could anyone please tell me why the following SQL statement does not update my DB?

$sql = "UPDATE $news_content SET id='$id', title='$edit_title', fname='$edit_fname', lname='$edit_lname', w_title='$edit_w_title', summary='$edit_summary', body='$edit_body', date='$edit_date' WHERE id='$id'

[mapexdrum]

I have changed all of the single quotes to escaped double-quotes, but still no dice.

[cgraz]

in the code you posted, yo'ur missing the last double quote.

Anyways, I'm assuming you have more than just this, right? All you have there is a variable with a string. It's not actual executed until you run mysql_query() on the string.

$result = mysql_query($sql) or die(mysql_error());

If that still doesn't help, print $sql and take a look at what the string looks like prior to executing it.

Cgraz

[mapexdrum]

I echoed the var. $sql and it wasnt passing the variable 'id' however the last double quote and terminator were present, I just didnt copy them or something.

Thanks for your help.