SQL Syntax Error (Aaaargh)

[noswad]

Hi

Im getting the following syntax error for the code below...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(no_access, type) WHERE no_access = 'noswad'' at line 1

if ($_POST[lift_user_ban] != "")
{

		$lift_user = "DELETE FROM banned (no_access, type) WHERE no_access = '$_POST[lift_user_ban]'";
		$result = @mysql_query($lift_user,$connection) or die(mysql_error());
		$msg .= "The Ban for user $_POST[lift_user_ban] has been lifted.<br>";

}

Can anyone see an error?

Thanks for looking.

 

[Eric]

DELETE syntax:

DELETE FROM table WHERE condition

Yours should be:

if ($_POST[lift_user_ban] != "")
{
    $lift_user = "DELETE FROM banned WHERE no_access = '$_POST[lift_user_ban]'";
    $result = @mysql_query($lift_user,$connection) or die(mysql_error());
    $msg .= "The Ban for user $_POST[lift_user_ban] has been lifted.<br>";
}

 

[noswad]

Thanks again SecondVersion :bingo: