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?

 

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

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

	$result	= mysql_query($sql); 

}

[Hailwood]

$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)