From: Terion Miller <webdev.terion@gmail.com>
Date: February 19, 2009 5:34:50 PM EST
To: Bastien Koert <phpster@gmail.com>
Cc: PHP General <php-general@lists.php.net>
Subject: Re: [PHP] Two troublesome fields
I just tried this and now it's not inserting at all where before everything
EXCEPT two fields go in...
$sql = "INSERT INTO workorders ( CreatedDate, Location, WorkOrderName,
AdminID, FormName, Status, Notes) VALUES (";
$sql .= "Now(), ";
$sql .= "'". mysql_real_escape_string($Location) ."', ";
$sql .= "'". mysql_real_escape_string($WorkOrderName) ."', ";
$sql .= "'". mysql_real_escape_string($AdminID) ."', ";
$sql .= "'". mysql_real_escape_string("WorkOrder") ."', ";
$sql .= "'". mysql_real_escape_string("New Order") ."', ";
$sql .= "'". mysql_real_escape_string($Notes) ."', ";
$WorkOrderID = mysql_insert_id();
mysql_query($sql);
There's no closing parethesis to VALUES, try...
$sql .= "'". mysql_real_escape_string($Notes) ."')";
Sean DeNigris
sean@clipperadams.com