php delete problem

[chuddyuk]

Before anyone says it, iv tried searchin the forum to see if i can work out why my script isnt working, but had no luck. its a simple one anyway:

im trying to delete records from my db using this code:
[code]
<?
include "connect.php";

$id = $_REQUEST['id'];

$query = "DELETE FROM gallery WHERE id = '$id'";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
echo "Database Updated.";

?>
[/code]
I get the error:
Cannot query the database.
Query was empty
anyone know where im going wrong? :)

[trq]

Your assigning your query to a variable called $query, then executing a query with the variable $sql.

Try...
[code]
$result = mysql_query($query) or die("Cannot query the database.<br>" . mysql_error());
[/code]

[chuddyuk]

Your a star mate, it was staring me right in the face. Much Appriceated!