<!-- ********************************************************************************
   pgm name : Modify.php
   purpose  : Find a record in table 
              To be used as an example for class
   author   : Michael Robinson
   Updated  : April 3, 2015
      
******************************************************************************** -->

//Modify.php
<?php
   date_default_timezone_set ('America/New_York');
   $connection = mysql_connect("server_location","user_name","password");
   
   //Test connection
   if (!$connection)
   {
      //ends this program and calls Data.php which is main program
      //this error could be done with javascript, so that the user
      //can read it and press OK to continue
      echo "Could not connect to sql server. " . mysql_connect_error();
   }
   else
   { 
      //since I am connected to mysql server I now connect to a database 
      $databaseName = "databaseName"
      $db_selected = mysql_select_db( $databaseName, $connection );
             
      if ( $db_selected )
      { 
         $sqlModify = "UPDATE tableName 
                          SET keyField = $_POST["keyField"], 
                              field1   = $_POST["field1"],
                              field2   = $_POST["field2"],
                              field3   = $_POST["field1"]                                                                  
                        WHERE keyField = $_POST["keyField"]
                      ";
                      
         $modify = mysql_query($sqlModify);
                   
         //test to see that record was modified
         if( !modify )
         {
             //there was an error while modifying the record
             //ends this program and calls Data.php which is main program
             //this error could be done with javascript, so that the user
             //can read it and press OK to continue
             die('Could not modify record ' . mysql_error());
         }

      }
      else
      {
         //there was an error selecting the database
         //ends this program and calls Data.php which is main program
         //this error could be done with javascript, so that the user
         //can read it and press OK to continue
         die('Could not select $databaseName ' . mysql_error());
      }
            
      mysql_close($db_selected);                     
      mysql_close($connection);            
             
   } 

   include('Data.php');

?>