MySQL insert not working...

[HitByASquirrel]

its.. just.. not... working...still...

$query = "INSERT INTO news VALUES
(NULL,'".$HTTP_POST_VARS['title']."',NOW(),$usernamevalue,'".$HTTP_POST_VARS['title']."')";
			echo "<br>".$query;
			$insertresult = mysql_query($query);
			if($insertresult) {
				echo "posted news";
			}

any insight to the changed code?

[ahundiak]

You might want to review the sql insert syntax. You want something like

"insert into news
(post,title,date,user,content)
values (... AS YOU POSTED ...)"

No 's around table and column names.

I didn't actually test your values syntax. Might be easier if you did something like
$content = $_POST['content'];
And then use $content in the query. You will end up having to clean it anyways.