Re: What is wrong with this INSERT?

Daniel I like your code ­ it¹s definitely cleaner and compact. I have a question for you ­ I have never used ³if($_POST) {³, instead, always felt I needed to specify the $Submit variable to check if form is submitted. So basically if I use ³if($_POST) {³, would it automatically mean it¹s checking if the form has been submitted? BTW: figured out the problem, as resolved by Tijnema, ³WHEN² is a reserved word in mySQL. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Rahul Sitaram Johari CEO, Twenty Four Seventy Nine Inc. W: http://www.rahulsjohari.com E: sleepwalker@rahulsjohari.com ³I morti non sono piu soli ... The dead are no longer lonely² On 3/29/07 10:32 AM, "Daniel Brown" <parasane@gmail.com> wrote: > > Try this code, cleaned up and made a little more compliant. > > <? > //Add Record Function > if($_POST) { > $db = mysql_connect("localhost","usr","pwd"); > mysql_select_db("thedb",$db) or die("Critical Error > :".mysql_error()); > $WHEN = date("mdyHi"); > $WHAT = $_POST['WHAT']; > $WHO = $_POST['WHO']; > echo "<SPAN CLASS='BlackText'>".$WHEN.", > ".$WHAT.", > ".$WHO."</SPAN><br>"; > $sql = "INSERT INTO tbl(WHEN,WHAT,WHO) > > VALUES('".$WHEN."','".$WHAT."','".$WHO."')"; > $result = mysql_query($sql) or die("Fatal Error:".mysql_error()); > echo "<span class='SmallText'><EM><STRONG>~: message > sent:~</STRONG></EM></span><BR><BR>"; > } > ?>