Re: What is wrong with this INSERT?

are you sure $_POST['Submit'] is set? i mean, do you have an input named "Submit" that is set in your form? Rahul Sitaram Johari wrote: > Ave, > > Does anyone know what I¹m doing wrong? > > <?php > //Add Record Function > if($_POST['Submit']) { > $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>"; > > mysql_query("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>"; > } > ?> > > I have a form which is sending POST data. Everything is working fine to this > statement: echo "<SPAN CLASS='BlackText'>$WHEN, $WHAT, > $WHO</SPAN><br>"; > > It is displaying POST data appropriately. It¹s just not Adding Records to > the Database! It¹s not giving any Errors!! This is not working: > mysql_query("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>"; > > Yes ­ tablename is fine > Yes ­ Fieldnames are fine ­ Connection is fine! > I¹ve double checked all these things. I¹m not getting any errors ­ it¹s just > not executing the INSERT for some reason!!! > > HELP! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > 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² > >