updating database information

[jrbush82]

I'm fairly new to php, trying to make some additions to vbb, and here is the code I have... the code that is below the s works during the post, but the code within the s doesn't (of course that is my code). I don't get errors though when I post.

Any help would be appreciated if you see what I'm doing wrong? I have added the columns of pubstros and pubs to the table user, and the values of each are set to 0.

// *****************************************************************************************
        if ($ftpdata[puborstro]==1 OR $ftpdata[puborstro]==2) {
          if ($ftpdata[puborstro]==1) {
            $DB_site->query("UPDATE user SET pubstros='pubstros+1' WHERE userid='$bbuserinfo[userid]'");
          } elseif ($ftpdata[puborstro]==2) {
            $DB_site->query("UPDATE user SET pubs='pubs+1' WHERE userid='$bbuserinfo[userid]'");
          }
        }
// *****************************************************************************************

    $DB_site->query("UPDATE user SET
    ".iif ($foruminfo[countposts],"posts=posts+1,","")."
    $dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'");
  }

[diego25]

pubstros='pubstros+1'
should be
pubstros=pubstros+1

otherwise MySQL (or whatever db you're using) will think that's a string and won't evaluate that as a mathemtical expression.

Diego

[jrbush82]

I auctually had it like that at one point, and changed it, but I changed back like you suggested, and still no luck. In my eyes it should work, but then again, most things should, and they don't, heh.

Thanks for the help. Any other ideas?