Since you are using a database abstraction layer, I do not know what type of database you are using, but if your object has debugging, why don't you turn it on and see if the database is throwing up an error. If it does not have debugging, I would suggest printing out the query instead of trying to run it, so you can see what is wrong with it.
> -----Original Message----- > From: Sebastian [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 2:33 PM > To: Jennifer Goodie; php list > Subject: Re: [PHP] no worky :| > > > 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
