[SOLVED] increment value in table?

[Dragen]

How do I increment an int variable by 1, in a table.

I'm currently using this code:

<?php
$clicks = $row['clicks']+1;
$result = mysql_query("UPDATE downloads SET clicks = '$clicks' WHERE down_id = '$id'") or die (mysql_error());
?>
which works, but it there a way of having clicks increment without having to use another variable?
such as:
[code]SET clicks = clicks++

I have tried the above, but it doesn't work..

 

I've tried searching for it and just found lots of sites about auto increment table types.. :-\

 

Thanks[/code]

[Onle]

As a best practice I would remove the ' from the values if they are both integers which the appear to be.

 

Second

$result = mysql_query("UPDATE downloads SET clicks = ".$row['clicks'] ." + 1 WHERE down_id = $id")

[jitesh]

update tablename set fieldname = fieldname + 1;

[Dragen]

Thanks all.

Worked perfectly...