Help w/mysqli

PHP
1

Hi guys, Please advise me here. The following code is a recent attempt at mysqli. It doesn’t update

<!DOCTYPE html>
        <html>
           <head>
             <title>Select taxrate</title><br>
              <style
                body
              { background: #ccffff; }
               form
              { text-align: center; }
             </style>
           </head>
        <body>
           <form name="form" action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
             <p><label>Select state/rate</label><br>
               <select name="taxrate">
                 <OPTION class=highlight value=0.04000 selected>4% - Alabama
                  <OPTION class=highlight value=0.00000>no tax- ALASKA
                   <OPTION class=highlight value=0.00056>5.6%- Arizona
                 </SELECT><p>
               <input type="submit" name="update_taxrate" value="submit"><p>
             </form></body></html>

 <?php
         if(isset($_POST['submit']))
         { $taxrate = $_POST['taxrate']; }
         $dbconnect = mysqli_connect('localhost','root','');
         mysqli_select_db($dbconnect, 'oodb') or die( "Unable to select database");
         $taxrate = (isset($_POST['submit'])) ? mysqli_real_escape_string($dbconnect,  $_POST['taxrate']) : '';
         $id = (isset($_POST['id'])) ? mysqli_real_escape_string($dbconnect, $_POST['id']) : '';
         $result = mysqli_query($dbconnect, "SELECT * FROM numbers");
         if (!empty($_POST['update_taxrate']))
         { $update = mysqli_query($dbconnect, "UPDATE numbers SET taxrate = '$taxrate' WHERE id ='$id'");
         echo "Taxrate              has been set ..."; }
        ?>
2

Your submit button isn’t called ‘submit’ but ‘update_taxrate’

3

Good spot guido2004. Also see this post.

4