was mache ich da falsch?

[(-KaZaA-)]

$query = "select * from nuke_clanwars where name='$cw'";
$result = mysql_query($query);


if (mysql_num_rows($result)) {
while($row=mysql_fetch_array($result)) {



$id= $row['id'];
$name = $row['name'];
$hp = $row['hp'];
$date = $row['date'];
$liga = $row['liga'];
$gm = $row['gm'];
$um = $row['um'];
$gs = $row['gs'];
$us = $row['us'];
$wl = $row['wl'];
}
}

$eintrag1 = MYSQL_QUERY( "DELETE FROM nuke_clanwars where name='$name' AND id='$id' AND hp='$hp' AND date='date' AND liga='$liga' AND gm='$gm' AND gs='$gs' AND um='$um' AND us='$us' AND wl='$wl'");

 

[Tob]

date='date' <= was soll das ???
wie wärs mit date='$date'

tob