Adding on mySQL fields

[Anon]

Hi,

I have a mySQL table which records points customers earn. Simple structure, just has an ID and points field. I need to run a simple sql query to add 5 to the points to the points field of a row. Can someone post the correct syntax for this.

Thanks.

Peter Meej

[Anon]

update table set points=points+5 where cust_id=$cust_id