I have the following select statement.

echo "<p>The Current Date Is: ".$the_date;
$query = "select * from `quiz` where quizdate = $the_date";
$result = $db->query($query);
$num_results = $result->num_rows;

$the_date contains the date I want, but the $query is failing, but the quiz table contains an entry with the same date...

I know dates can be tricky. The quizdate field is format date and it looks like:
2009-05-01

TIA, Dave