Two troublesome fields not inserting

[email protected] (Terion Miller)
Newsgroups php.db
Message-ID <[email protected]>
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();

Here is the part where it calls the old values:

    $sql2 = "SELECT Location, WorkOrderName FROM workorders WHERE
WorkOrderID='$WorkOrderID'";
    $result2 = mysql_query ($sql2);
    $row2 = mysql_fetch_array($result2);


Here is the form part:

    <tr>
                        <td align="left" nowrap><div
class="CaptionReq">Property:</div></td>
                        <td align="left"><div><input type="hidden"
name="Location" value="<?php echo $row2['Location']; ?>"><?php echo
$row2['Location']; ?> </div></td>
                    </tr>
                    <tr>
                        <td align="left" nowrap><div class="CaptionReq">Work
Order Name: <?php echo $row2['WorkOrderName']; ?></div></td>
                        <td align="left"><div><br><input type="hidden"
name="WorkOrderName" size="35 " value="<?php echo $row2['WorkOrderName'];
?>"/></div></td>
                    </tr>

I need some clues, everything works except the two fields Location, and
WorkOrderName.....

Thanks
Terion

Happy Freecycling
Free the List !!
www.freecycle.org
Over Moderation of Freecycle List Prevents Post Timeliness.
------------------------------------------------
Twitter?
http://twitter.com/terionmiller
------------------------------------------------
Facebook:
<a href="http://www.facebook.com/people/Terion-Miller/1542024891"
title="Terion Miller's Facebook profile" target=_TOP><img src="
http://badge.facebook.com/badge/1542024891.237.919247960.png" border=0
alt="Terion Miller's Facebook profile"></a>
Katharine Hepburn  - "Life is hard. After all, it kills you."
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.