What is wrong with this INSERT?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ave,

For total clarity, I¹m starting this post again. I messed up big time with
my posts.
So here¹s my actual code:

    <?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>";
                   
    $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>";
    }
    ?>

Now, this part is working absolutely fine and printing out echo values:
    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>";

But this part is not working ­ and not giving any errors:
    $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>";
    }

Thanks!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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²


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux