title: Change LIMIT in MySQL without refreshing
body: <p>So basically what I want is when you click on a link, the <strong>$limit</strong> variable in my MySQL Query should be increased by 10 without refreshing the page. I know there are many similar questions, but I just couldn't work it out.    </p>
  
  <h3>index.php</h3>
  
  <pre><code>&lt;?php  
  $limit = 10;  
  
  mysql_connect("localhost", "root", "");
  mysql_select_db("database");
  
  $query = mysql_query("SELECT * FROM news ORDER BY news_id DESC LIMIT $limit");       
  ?&gt;
  
  &lt;a href="#" id="more"&gt;Show more...&lt;/a&gt;
  </code></pre>
  
  <h3>javascript.js</h3>
  
  <pre><code>$('#more').click(function(){
      //Now here some jQuery / AJAX that changes the PHP $limit variable?
  });
  </code></pre>
  
  <p>Is this possible in any way? I know that Javascript is on the client and PHP on the server side and my MySQL is up to date so the variable inside the query works. The title could've been 'How the change a PHP variable with jQuery' aswell, but if that's not possible I really need another solution to dynamically change the query (maybe even with refreshing).    </p>
  
  <p>Thanks :)</p>