Increment a field value

Hi Everyone, I want to increment the value of a field in a table by 1. How do I go about this? I tried 'update...hits+=1' but it didnt work. Your response would be appreciated. Rgds, - How low will we go?

MySql function

Hi Everyone, i did the following $dbh-prepare(UPDATE contentTable SET filename = '$dbfile date_modefied = 'CURRENT_DATE()' time_modefied = 'CURRENT_TIME() WHERE ext = '$ext' ) and the value of the current date and current time were not updated on the table. It seems perl