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

Reply via email to