increment with update in mysql query code example
Example: mysql increment value by 1 in update
mysql_query("
UPDATE member_profile
SET points = points + 1
WHERE user_id = '".$userid."'
");
mysql_query("
UPDATE member_profile
SET points = points + 1
WHERE user_id = '".$userid."'
");