INSERT INTO question

[jbachris]

First off, I'm using AdoDB411, which is great.

I have setup a news comment system, but when I run the following sql to insert the content comment info does not insert into the database, but the rest of the info does.

I have this form:

<form action="<? echo $PHP_SELF; ?>" method="POST">
<table width="480" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="contentHeader">Add A Comment</td>
	</tr>
	<tr>
		<td class="contentContainer">
			<table width="480" cellpadding="0" cellspacing="0" border="0" align="center">
				<tr>
					<td class="contentItems"><b>Username:&nbsp;&nbsp;&nbsp;</b><? print $userdata['username'] ?></td>
				</tr>
				<tr>
					<td class="contentItems"><b>Comment:</b>
					<br />
					<textarea id="comment" name="comment" cols="50" rows="3" wrap="virtual"></textarea></td>
				</tr>
				<tr>
					<td class="contentItems"><input name="add_comment" type="submit" id="add_comment" value="Add Comment" class="bttn"> <input type="reset" value="Reset" /></td>
				</tr>
			</table></td>
	</tr>
</table></form>

and this sql:

$sql = "INSERT INTO news_comment(comment, newsID, user_id, nc_date, live) VALUES('$comment'," . $_GET['newsID'] . "," . $userdata['user_id'] . ",NOW(),1)";

Any help would be greatly appreciated.

[Pieman86]

Try this:

$sql = "INSERT INTO news_comment(comment, newsID, user_id, nc_date, live) VALUES('$comment', '" . $_GET['newsID'] . "', '" . $userdata['user_id'] . "', NOW(), 1)";

I just inserted some single quotes in there...I think that's what's causing the problem.