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