Hello all, I am trying to update a table with the record id for a priority selected from another table. I don't understand how the record id for the record I am trying to update is passed.
On my PHP page named "lead-001.php" I have the following: <script type="text/javascript"> $(document).ready(function() { $('.select_priority').editable('/lead/lead-006.php', { loadurl : '/lead/lead-005.php', indicator : '<img src="/images/spinner.gif">', type : 'select', onblur : 'cancel', submit : 'OK', tooltip : 'Click to edit...' }); }); </script> With the field: <div class="select_priority" id="fldPriorityID"><?php echo $priority; ? ></div> I am able to click on the field and select from the drop-down the following values from "lead-005.php": {"2":"High","4":"Low","3":"Medium","1":"Urgent","selected":"1"} For troubleshooting I am just echoing the SQL in "lead-006.php". Instead of getting something like this (where 2 is the record id for the record I am trying to update): "Update tblLeads set fldPriorityID = 4 where fldLeadID = 2;" I get this: "Update tblLeads set fldPriorityID = 4 where fldLeadID = fldPriorityID;" Why is this happening? How can I tell "lead-006.php" that I am trying to update record with the id number 2. Thanks, Charles