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@xxxxxxxxxxxxxxxx
³I morti non sono piu soli ... The dead are no longer lonely²
On 3/29/07 10:32 AM, "Daniel Brown" <parasane@xxxxxxxxx> 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>";
> }
> ?>
