title: Adding an integer to primary key auto-increment mysql php ajax
body: <p>I have a form that I submit with an ajax call where the primary key which is the 'id' column is set to auto increment.</p>
  
  <p>When I post without stating an ID it works fine and items are entered to the table in an increment of 1.</p>
  
  <p>What I am trying to do is tell my query what ever the next auto increment is...for example it is now at 5,  I want it to add 10 to the 5 that it currently is at and so it enters the id as 15.  can someone help me with the syntax because I can't seem to get it to work..again it posts fine without the id stated in the query.</p>
  
  <p>here is the query as it stands not working. BTW I already know it is not a great idea to mess with the primary key but in this situation it is a quick fix to a yucky problem that I will  address after they are back up and running.  </p>
  
  <pre><code>$sql = "INSERT INTO Products
      (id, item, description, shelf, active) 
  VALUES 
      ('".id."'+ 10, '".$item."', '".$description."', '".$shelf."', '".$active."')";
  </code></pre>
  
  <p>Thanks</p>