title: SQL not updating Row
body: <p>I have tried to get this working for a couple hours now, i think its related to the fact that i have a $_GET['ID']; on the first script but im not sure:</p>
  
  <p>Script 1 (FORM):</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
   require_once('db_access.php');
   $editID = $_GET['id'];
      $query = mysql_query("SELECT * from routes where id = '".$editID."'");
      $row = mysql_fetch_assoc($query);
  ?&gt;
  
  &lt;!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
  "http://www.w3.org/TR/html4/loose.dtd"&gt;
  &lt;html&gt;
  &lt;head&gt;
  &lt;title&gt;Form Edit Data&lt;/title&gt;
  &lt;/head&gt;
  &lt;body&gt;
  &lt;table border=1&gt;
    &lt;tr&gt;
      &lt;td align=center&gt;Route Edit Data&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;
        &lt;table&gt;
        &lt;form method="post" action="complete_edit.php"&gt;
          &lt;tr&gt;        
            &lt;td&gt;ID #&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="hidden" name="formid" value="&lt;?php echo $row['id'] ?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Route Name&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="route_title" size="40" 
            value="&lt;?php echo $row['route_title']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Total Price&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="total_price" size="40" 
            value="&lt;?php echo $row['total_price']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Down Payment&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="down_payment" size="40" 
            value="&lt;?php echo $row['down_payment']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Weekly Net&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="weekly_net" size="40" 
            value="&lt;?php echo $row['weekly_net']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Location&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="location" size="40" 
            value="&lt;?php echo $row['location']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td&gt;Remarks&lt;/td&gt;
            &lt;td&gt;
              &lt;input type="text" name="remarks" size="40" 
            value="&lt;?php echo $row['remarks']?&gt;"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
            &lt;td align="right"&gt;
              &lt;input type="submit" 
            name="submit value" value="Edit"&gt;
            &lt;/td&gt;
          &lt;/tr&gt;
        &lt;/form&gt;
        &lt;/table&gt;
      &lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
  &lt;/body&gt;
  &lt;/html&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>SCRIPT 2(PROCESSING): </p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;?php
    $id = $_POSt['formid'];
    $editroute = $_POST['route_title'];
       $editprice = $_POST['total_price'];
       $editdownpay = $_POST['down_payment'];
       $editweeklynet = $_POST['weekly_net'];
       $editlocation = $_POST['location'];
       $editremarks = $_POST['remarks'];
  
       $query = "UPDATE routes SET id = '$id', route_title = '$editroute', total_price = '$editprice', down_payment = '$editdownpay', weekly_net = '$editweeklynet', location = '$editlocation', remarks = '$editremarks' WHERE id = '$id'";
       header('Location:index.php');
  ?&gt;      </code></pre>
  </div>
  </div>
  </p>
  
  <p>The first lot of code is where my form is placed and the second is where the processing happens
  Thanks for your help people :)
  Alex</p>