DELETE FROM not working

[canadawest]

OK here's a puzzler, for me at least.

These two bits of code are nearly identical. The SELECT query returns lines form the mysql table where the Date of the Event is passsed. The DELETE query doesn't delete them. Why doesn't the DELETE query work?

$sql = "SELECT * FROM strata3_events WHERE Date < '$today'";     

$result = mysql_query($sql) or  error(mysql_error());

$sql = "DELETE * FROM strata3_events WHERE Date < '$today'";     

$result = mysql_query($sql); or  error(mysql_error());

[dagon]

• is erroneous, your have to delete the whole row, so * makes no sense