Two troublesome fields not inserting

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux