add value to current value in DB

ah yes here we go again another somewhat simple for you, hard for me task!

i want to make it so when a user logs in and completes the login form, their "user_clanrank" value is updated. instead of replacing it with a new value i want to simply add 5 to whatever is already there.. this would include login.php and a panel from where they login i suppose.. most likely you wont need to code for those pages to help me here tho

[Join us @ facebook]

You have to add an SQL query which will be something like :

Code:

UPDATE users SET user_clan = user_clan + 5 WHERE userID = $userID LIMIT 1

ty for refreshing my memory .. i knew the answer to this one i just .. have some memory losss.. for some reason.. ill show the working code (for what im doing) after i finish apply nik's snippet

for some reason, this code is doubling the value (i put 1, and it adds 2)

Code:

<?php /*there is more before this...*/
if (iADMIN && (iUSER_RIGHTS != "" || iUSER_RIGHTS != "C")) {
echo "<br><span class='small'><b>".$locale['on109']."</b></span><br />";
echo "<span class='small'>°</span> <a href='".ADMIN."index.php".$aidlink."' class='side'>".$locale['on110']."</a><br>\n";
echo "<span class='small'>°</span> <a href='".BASEDIR."administration/news.php".$aidlink."' class='side'>".$locale['on111']."</a><br>\n";
echo "<span class='small'>°</span> <a href='".BASEDIR."administration/articles.php".$aidlink."' class='side'>".$locale['on112']."</a><br>\n";
echo "<span class='small'>°</span> <a href='".BASEDIR."infusions/calendar_panel/calendar.php?funk=addein&km=".aidlink."' class='side'>Add Event</a><br>\n";
}
} else {
openside($locale['on122']);
echo "<div align='center'>".(isset($loginerror) ? $loginerror : "")."<form name='loginform' method='post' action='".FUSION_SELF."'>".$locale['on123']."<br>";
echo "<input type='text' name='user_name' class='textbox' style='width:100px'><br>".$locale['on124']."<br>";
echo "<input type='password' name='user_pass' class='textbox' style='width:100px'><br>";
echo "<input type='checkbox' name='remember_me' value='y' title='".$locale['on125']."' style='vertical-align:middle;'>";
echo "<input type='submit' name='login' value='".$locale['on126']."' class='button'><br></form><br>\n";
dbquery('UPDATE fusion_users SET user_cpts = user_cpts + 1 LIMIT 1');
if ($settings['enable_registration']) {
echo "".$locale['on127']."<br><br>\n";
}
echo $locale['on128']."</div>\n";
}
closeside();
?>

[Join us @ facebook]

I am not sure about this.

Maybe this code is executed on every new page, or you just refreshed the page by accident.

nope not refreshing page, but i had to take this off, it was only working for my account and no one elses (For some reason..)

[Guest]

[36.302]

Yahoo crawler, Googlebot, Gigabot