Chris wrote:
> Terion Miller wrote:
>> Hi all, I seem to be having a problem with getting two fields to insert
>> into a table, the other fields insert but not these two
>> its from a form that is a duplicate, basically I have a workorder that I
>> want to make a copy of, I call it from the db, populate a form in case
>> changes want to be made, and insert with a new unique ID as a new record,
>> it's working great except Two fields will NOT insert and I'm at a loss
>> for why ...
>> the code is big so I will post snippets that I think may be the trouble
>> spots
>>
>> Here is the insert:
>> $sql = "INSERT INTO workorders (CreatedDate, Location, WorkOrderName,
>> AdminID, FormName, Status, Notes) VALUES (";
>> $sql .= "Now(), '$Location', '$WorkOrderName', '$AdminID',
>> 'WorkOrder',
>> 'New Order', '$Notes')";
>> mysql_query($sql);
>> $WorkOrderID = mysql_insert_id();
>
> My immediate guess is either a single quote or a new line is causing the
> problem.
>
> You need to escape your data (use mysql_real_escape_string).
>
And don't forget debugging tools: echo the query and use mysql_error()
Cheers
--
David Robley
"I love hot dogs," said Tom with relish.
Today is Sweetmorn, the 51st day of Chaos in the YOLD 3175.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
