Update database by each visit

[Marc]

I'm trying to implement a script that updates my database table everytime someone is visiting a members profile.

Every time the page get's loaded it needs to update that persons profile with 1 visit.

	mysql_query("UPDATE `dt_profile` SET `visits` = '$visits+1' where member_id = '$member_id'")or die(mysql_error()); 

This isn't working!!!!
Any ideas on how to get it right?????
Thanks

Marc

[yahelb]

change:
SET visits = '$visits+1'
to:
SET visits = visits+1

that shou work

[Marc]

Great, it's working ;-) !! thanks for your help.