Update query not working

[loony383]

hey, can anyone help me i cant get this update query to work.

 

$updateforum="update ab_forum set numposts=numposts+'1',name=name, forumid=forumid, description=description WHERE forumid='$forumid'";

mysql_query($updateforum) or die("Could not update forum");

[BaneStar007]

I don't know whats right, but I always make sure my variables are static before I put them into the query,

 

Also, numposts+'1'

 

is this a varchar? it should be .'1'

if its a number(int) then `(numposts+1)`  <-- not static 

[nloding]

Off what BaneStar said, I think you're going for this:

 

UPDATE ab_forum SET numposts='($numposts+1)',name='$name',forumid='$forumid',description='$description' WHERE forumid='$forumid';