Posted by Ewoud Dronkert on 11/03/26 11:32

John McClumpha wrote:
> is there a simple (quick) way to increase the value of an integer
> field in a nominated row by 1

$id = 42;
mysql_query('UPDATE tablename SET fieldname = fieldname + 1 WHERE recordid
= '.$id);

--
E. Dronkert

[Back to original message]