Posted by Ewoud Dronkert on 10/17/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

• Next in forum: Re: increase MySQL field value by 1? (quickly/easily)
• Prev in forum: increase MySQL field value by 1? (quickly/easily)
• Thread view: Re: increase MySQL field value by 1? (quickly/easily)

[Reply to this message]