Topic: Need Help with Updating Number of User posts.

[liquidspaceman]

Hello Everyone,

I am having an issue with updating the number of users posts when they post to my forum. This is the code I am using but the "post" field in the table does not update to show the new number of posts in the forum. Help?

Code: [Select]

$sql = "update tbl_user set post=post+1

where (id='$user_id') and (code='$user_code')";

$result = mysql_query($sql);

}

[Hailwood]

Code: [Select]

$sql   = "update tbl_user set post=post+1
where id='".$user_id."' and code='".$user_code."'";
$result   = mysql_query($sql);
}
try that.


Regards,
Hailwood

[liquidspaceman]

Thanks Haliwood. Didn't work unfortunately. Still not updating the post count.

Any other ideas?

[jl5501]

is the post field in the table defined as an integer?

[liquidspaceman]

Yes. It is defined as INT(11)