[SOLVED] Simple sql update statement
Posted: Fri Aug 27, 2004 2:32 pm
This is bugging me to the point of no return, i have almost the entire forum working, all i have left is a few minor details. when i relize i forgot to update how many posts are in a forum after posting that that forum.
Ive done this before, so i just added a quick little piece to take the current posts, add one, then in the update statement update the posts.
The entire thing works ECEPT the part that updates 'posts'. I have no idea what going on here....
Thanks in advanced.
Ive done this before, so i just added a quick little piece to take the current posts, add one, then in the update statement update the posts.
Code: Select all
$sql4 = mysql_query("UPDATE f_forums SET lp_date='" . date("Y-m-d H:i:s") . "', lp_id='$poster_id', lp_name='$poster_name, posts='$posts' WHERE id='$forum'");Thanks in advanced.