<?php
    $con = mysql_connect("localhost","root","");
    if (!$con){
        die('Could not connect: ' . mysql_error());
      }
 
    // Select database
    mysql_select_db("Library", $con);
   

    // Update user   
    $sql = "DELETE FROM Users WHERE Name = 'Rita'";       
    $result = mysql_query($sql);
   
   
    // if successfully insert data into database, displays message
    if($result){
        echo "Delete Command: $sql  is successfully executed";
       
    }
    else {
        echo "ERROR while deleting the data";
    }

    $query="SELECT * FROM Users";
    $result=mysql_query($query);
    $num=mysql_numrows($result);

    mysql_close();

    echo "<b><center>Database Output</center></b><br><br>";

    while($row = mysql_fetch_array($result)){
        echo $row['Name'] . " " . $row['UserType']. " " . $row['UserId'];
        echo "<br />";
    }

   
    mysql_close($con);
?>