Delete data from database table : Database Delete « MySQL Database « PHP

1. PHP
2. MySQL Database
3. Database Delete

Delete data from database table

<?php
   mysql_connect("mysql153.secureserver.net","java2s","password");
   mysql_select_db("java2s");

   $rowID = "001";
   $query = "DELETE FROM Employee WHERE ID='$rowID'";
   $result = mysql_query($query);

   if ((mysql_affected_rows() == 0) || mysql_affected_rows() == -1) {
        echo "<p>There was a problem deleting some of the selected items.</p>";
        exit;
   }
?>

           
       

Related examples in the same category