Syntax error

[Canman2005]

Hi all

Why do I get a syntax error when using the sql statement


[code]if ($_GET['action'] == "add")

{    
$sql ="UPDATE users SET type = 4 WHERE id = $id";
@mysql_query($sql, $connection) or die(mysql_error());

}[/code]

I have a action also to delete a row which seems to work fine.

Thanks in advance

Ed

[Barand]

Are you sure you have a value for $id, or is your query

$sql ="UPDATE users SET type = 4 WHERE id = ";

As well as outputting mysql_error(), echo the $sql also.