On 3/29/07, Rahul Sitaram Johari <sleepwalker@xxxxxxxxxxxxxxxx> wrote:
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!
Well, let me post my reply another time :)
If you checked the MySQL Manual you would see that WHEN is a reserved
word. I think that gives problem, so you could change the WHEN key
into another key, or use some quotes around it. I recommend the first
option :)
Tijnema
ps. List of reserved words for MySQL:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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²
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
