title: Mysql PHP - Sort table after inserting row
body: <p>How can I have my table sort after a row has been inserted?</p>
  
  <p>I tried the following code but am getting an error:</p>
  
  <pre><code>$sql = "INSERT INTO vendors (vendor, pavcode, pavname) VALUES (?, ?, ?) ORDER 
  BY vendor ASC";
  </code></pre>
  
  <p>Thanks for any help.</p>
  
  <p>Edit: I am getting a syntax error as follows:</p>
  
  <blockquote>
    <p>ERROR: Could not prepare query: INSERT INTO vendors (vendor, pavcode, pavname) VALUES (?, ?, ?) ORDER BY (vendor) ASC. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY (vendor) ASC' at line 1</p>
  </blockquote>