$result=mysql_query("SELECT * FROM forum_messages WHERE thread='$thread' AND parent='0'"); $result_array=mysql_fetch_array($result); $hits=$result_array['hits']; $hits++; echo $hits; mysql_query("UPDATE forum_messages SET hits='$hits' WHERE id='$id'");