title: echo integer from table with mysql
body: <p>I'm building a user database for my website. One of the table columns is "id" where the user is given a reference number. In order to add new users, I have to select the last-registered user, extract the ID, add 1 to it, then submit that back into a new row for the new user.
  I'm currently using:</p>
  
  <pre><code>$query = mysql_query("SELECT MAX(id) FROM users;");
  </code></pre>
  
  <p>to select the maximum ID number. When I added 1 to that and tried to echo, it printed
   "Request ID#3" in the browser.</p>
  
  <p>How do I write a script that will take the highest ID, add one, and use it for the new registering user?</p>