Still struggling.

[130zewe]

I want to be able to delete all the User's Information by just entering in the User's name. Is this SQL query code close? I am also getting this error: Parse error: parse error, unexpected $ in /home/takach/public_html/admin/get_user.php on last line of my code. Any help would be appreciative.

<b><br><br>Please enter in User Name for the user you want to delete</b>
<form action="'.$_SERVER['PHP_SELF'].'" method="post">
User Name: <input type="text" name="user_name" value="'.$user_name.'">
<input type="submit" value="Submit">
</form>

<?php
#connect to MySQL
$conn = @mysql_connect("localhost","takach","")
or die("Could not connect to MySQL");
#select a database
$db = @mysql_select_db("takach",$conn)
or die("Could not select database");
#create the SQL query
$sql = "delete * from users where user_name = '.$user_name'";
#execute the query
$result = @($sql,$conn)
or die("Could not execute query");
if($result)
{
$msg ="User $user_name deleted";
}
}
echo($msg);
?>

[zonewatcher]

I believe the "else" is missing. Many times the error will be displayed referencing a line after the actual error occurs. Is this what you are trying to achieve in the last segment??

if($result) { 
  $msg ="User $user_name deleted"; 
} else {
  echo($msg);
}