Re: [PHP-DB] Two troublesome fields not inserting

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).

-- 
Postgresql & php tutorials
http://www.designmagick.com/