help with mysql query, Insert record related.

[yeochins]

I'm having one problem and that is inserting into the database. I know the varible gets to the function (because It redirects back to the proper place with the varible specified) but the mysql query doesn't insert the record for some reason.

function userpostcomment($subject, $message, $username, $time, $cid) {
global $subject, $message, $username, $time, $cid;
include("header.php");
tabletop();
   mysql_query ("INSERT INTO comments VALUES (NULL, $subject, $time, $username, $message, $cid)");
   echo "<center><b>Successfully Posted Comment\n";
   echo "<meta http-equiv=\"refresh\" content=\"3;URL=index.php?index=vc&viewcomment=$cid\">\n";
tablebottom();
include("footer.php");
}

[ahundiak]

You need to put single quotes around all the character data being inserted

VALUES(NULL,'$subject', ...

(Doesn't hurt in mysql to put the quotes around integer data either, but leave the NULL unquoted).