title: ALTER TABLE AUTO INCREMENT
body: <p>I am having  a problem with ALTER TABLE AUTO-INCREMENT. it does altered the table to 100 but it does not auto-increment. hope anyone can help me.. here is my code. thanks in advance.</p>
  
  <pre><code>$con=mysqli_connect("localhost","root","","info"); 
  // Check connection
  
  if (mysqli_connect_errno())
    {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
  
  $sql= "ALTER TABLE profile AUTO_INCREMENT=100";
  
  
  if (!mysqli_query($con,$sql))
    {
      die('Error: ' . mysqli_error($con));
    }
  
  if (isset ($_POST['Register!']))
  {
      $sql = "INSERT INTO staff_profile (name, age, address) 
      VALUES ('$name', '$age', '$address')";
      mysql_query($sql) or die (mysql_error());
  }
  </code></pre>