reset credits

[lggx2002]

I wrote a this in character.class.php, want to get additional credits on reset but it don't works. what's wrong here?

$credits = $db->Execute("select credits from MEMB_CREDITS where memb___id=?",array($loginid));
$rescredits=$credits + 5;

if($error!=1){
$sql_reset_script="Update MEMB_CREDITS set [credits]='$rescredits' where memb___id=?";}

please help to correct...

[MentaL]

[lggx2002]

fixed myself...

[JaneX]

can you share? :D if its ok ^_^

[lggx2002]

shared...