mysql update query

[safra]

Hi,

I have some sort of a counter on my pages associated with a column of a mysql table.

Is it possible to increment the value of a column of a specific row with 1 without first doing a select query to get the current value?

Thanks

[jacob_kochi]

$query="upate table set num=num+1 where id='$id'";
mysql_query($query);

"table" is table name.
"num" is field name
"id" is record id

[safra]

that's easy, thanks!