Update Employee table : Database Update : MySQL Database PHP Source Code


PHP Source Code » MySQL Database » Database Update »

 

Update Employee table




<?php

   mysql_connect("mysql153.secureserver.net","navioo","password");
   mysql_select_db("navioo");

   $rowID = "0001";
   $name = "Kate";
   $price = "12";

      $query = "UPDATE Employee SET name='$name', price='$price' WHERE ID='$rowID'";
      $result = mysql_query($query);

      if ($result
         echo "<p>The developer has been successfully updated.</p>";
      else 
         echo "<p>There was a problem updating the developer.</p>";



?>
           
       



HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo MySQL Database
» Database Update