Re: What is wrong with this INSERT?

On 3/29/07, Rahul Sitaram Johari <sleepwalker@rahulsjohari.com> wrote:

BY THOR! That worked! "WHEN" Is a reserved word and that is what was causing the problem. Changed it to "THETIME" and query went through fine!! Can't thank you enough! This was driving me crazy! Look how many mistakes I made in just making this post in this mailing list! Honorable *bow* Thanks!

You're welcome :) Sometimes this list isn't just that organized, and because mail servers aren't always returning email directly, some people are replying on old mails, while others are replying on new mails. (like i'm doing now, you send another email already :) ) Tijnema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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:30 AM, "Tijnema !" <tijnema@gmail.com> wrote: On 3/29/07, Rahul Sitaram Johari <sleepwalker@rahulsjohari.com> wrote:

My Apologies Everyone! I gave you all the wrong code Twice!! A pox on me - I tell you! This is the ACTUAL code that I'm working with - and it's not working: <?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>"; } ?> Please disregard the previous code I sent. Thank you!

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

<snip>