how do i make it right ?
<?php // Database Constants define("DB_SERVER", "localhost"); define("DB_NAME", "audi"); define("DB_USER", "root"); define("DB_PASS", "123456"); // Create a database connection $connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS); if (!$connection) { die("Database connection failed: " . mysql_error()); } // Select a database to use mysql_select_db(DB_NAME,$connection); ?> <html> <head> <title>Delete Users</title> </head> <body> <?php $username = isset($_POST['react']) ? $_POST['react'] : NULL; if(!empty($username)) { $query= "DELETE FROM users WHERE username = '$username'"; $result = mysql_query($query,$connection); if(mysql_num_rows($result)) { echo("<strong>$username</strong>Successfully Deleted<p>"); } else { echo("<strong>no users are available to delete yet, sorry. </strong><p>"); } } ?> <form method="post" action="Delete_user.php"><div align="center"><center><p>Delete users <input type="hidden" name="react" value="delete_user" /> <select name="user" size="1"> <?php $query = "SELECT username FROM users ORDER BY username"; $result = mysql_query($query,$connection); if(mysql_num_rows($result)){ //we have atleast one user,so show all users as options in select while ($rows = mysql_fetch_row($result)) { echo("<option value=\"$rows[0]\">$rows[0]</option>"); } } else { echo("<option value=\"\">Please Select User</option>"); } ?> </select><input type="submit" value="submit"></p></center></div> </body> </html>