thanks for pointing that out.... yeah, you're right it was wrong, should be "UPDATE news_comments SET .... WHERE ..."
since there was already a row. ... still can't get it to post to the database though. cheers, - Sebastian ----- Original Message ----- From: "Jennifer Goodie" <[EMAIL PROTECTED]> | Have you checked to make sure your query works, the syntax looks really odd. | I've never seen INSERT ... WHERE | | > -----Original Message----- | > From: Sebastian [mailto:[EMAIL PROTECTED] | > Sent: Thursday, April 03, 2003 2:20 PM | > To: php list | > Subject: [PHP] no worky :| | > | > | > Hello, | > | > This form is really giving me a fight. | > | > I am connected to the database, yet it won't submit, Is the form and | > $_POST's Okay? | > | > echo " | > <form name=\"sendform\" action=\"report.php\" method=\"post\"> | > reason: <br> | > <textarea name=\"reason\" cols=\"50\" rows=\"3\"></textarea> | > <br/><br/> | > <input type=\"submit\" name=\"report\" value=\"mark for moderation\"> | > </form>"; | > | > if($_POST[reason]) { | > $result = $db->sql("INSERT INTO comments (reported, reportedby, reason) | > VALUES ('1', '$username', '$_POST[reason]') WHERE id = '$id'"); | > | > if($result) { | > echo "<center>message sent to moderators.<br/><a | > href=\"$_SERVER[HTTP_REFERER]\">return to your previous | > page</a>.</center>"; | > | > } | > } | > | > | > cheers, | > - Sebastian | > | > | > | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php