title: I need to pass a php variable to DataTables.Editable sUpdateURL
body: <p>Hi I need to pass a variable called <code>$process_id</code> to the file <code>"config/update.php"</code> which is the file responsible for live table updating using DataTables.Editable.</p>
  
  <p>This variable is an integer used to create a table (e.g. table1) so to update the specific table I need to have <code>UPDATE table$process_id SET...</code> and to be able to do that I need to pass  that variable to the script that updates the table.</p>
  
  <p>Here's what I came up with after some research on the <a href="http://code.google.com/p/jquery-datatables-editable/w/list" rel="nofollow">Datatables.Editable Wiki</a>:</p>
  
  <p>DataTables initialisation and addition of makeEditable function:</p>
  
  <pre><code>$('#example').dataTable().makeEditable({
      sUpdateURL: "config/update.php",
      oUpdateParameters: { 
          "process_id": "&lt;?php echo $process_id; ?&gt;"
      }
  });
  </code></pre>
  
  <p>And the <code>update.php</code> file</p>
  
  <pre><code>&lt;?php
  $id = $_REQUEST['id'] ;
  $value = $_REQUEST['value'] ;
  $column = $_REQUEST['columnName'] ;
  $columnPosition = $_REQUEST['columnPosition'] ;
  $columnId = $_REQUEST['columnId'] ;
  $rowId = $_REQUEST['rowId'] ;
  $column_name = trim($column);
  
  $process_id = $_REQUEST['process_id'];
  
  include("config.php");
  
  // mysql_query(" UPDATE $sTable SET $column = $value WHERE trl_id = $id ");
  mysql_query("UPDATE tw_tg_sim_lines$process_id SET $column_name = '$value' WHERE trl_id = '$id'");
  
  echo $id;
  
  ?&gt;
  </code></pre>
  
  <p>I have already tried the different methods such as $_POST, $_GET and $_REQUEST. Nothing seems to work, so the problem is in the <code>oUpdateParameters</code>.</p>
  
  <p>Any help would be much appreciated, thank you.</p>