Data won't update

[fizzwizz]

I cant get my data to update.
I seem to have tried every permutation of syntax I can think of but nothing works. I have searched this forum but the syntax given doesn't work for me. This is the code I have..

$link_id = db_connect();
$result = mysql_query("UPDATE counter SET unique='2',hits='3',id='1' WHERE id='1'",$link_id);

is there something wrong with this?
db_connect() connects fine with my other SQL queries

thanks

[TheIceman5]

well the field you have there 'unique' is an actual sql command and may not work in a query as a field name.

[fizzwizz]

TheIceman5 ...... YOU ARE A GOD!!!!!!

Thanks .....