Extract by date

[Noumenon]

I'm trying to make my script show Live Dates that haven't happened yet from my DB.
But the syntax is wrong: DATE_FORMAT(date,'%a, %b %D, %Y') AS date WHERE date >= CURDATE()
How should this be done?

<?php
$sql = "SELECT DATE_FORMAT(date,'%a, %b %D, %Y') AS date WHERE date >= CURDATE(), place, tickets FROM live ORDER BY id DESC";
$result = @mysql_query($sql) or die("Error with mysql query on line ". __LINE__.".<BR />". mysql_error());

if (@mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
echo '<TR>'."\n";
echo ' <TD ALIGN="center"><FONT>'.$row['date'].'</FONT></TD>'."\n";
echo ' <TD ALIGN="center"><FONT>'.$row['place'].'</FONT></TD>'."\n";
echo ' <TD ALIGN="center"><FONT>'.$row['tickets'].'</FONT></TD>'."\n";
echo '</TR>'."\n";
}
}
?>

[Noumenon]

Solved it.
SELECT DATE_FORMAT(date,'%a, %b %D, %Y') AS date, place, price FROM live WHERE date >= CURDATE() ORDER BY id DESC