[SOLVED] pulling things just for TODAY?

[galvin]

I'm getting stuck trying to figure this out and I know it's simple.

 

 

I have a mysql table called 'cases' where each entry has an 'entrydate' field (i.e the date it's entered) in the format of:

 

2009-09-18

 

Each day, I want to pull everything from that table that only has TODAY's date (i.e. the current date).

 

So I know this is close, but what goes where I have "**TODAY***

 

$sqlquery = "SELECT * FROM cases
WHERE entrydate = **TODAY**"; 
$result = mysql_query($sqlquery); 
$numbercases = mysql_numrows($result); 

echo "<span class='numcases'> Today there are $numbercases cases.</span>";

[YourNameHere]

// if you need the day to not have leading 0s then replace the "d" in the date() method to "j"
//for example this code will format it like this 2009-09-01, but with "j" it will format like this 2009-09-1
$date=date('Y-m-d');
$sqlquery = "SELECT * FROM cases
WHERE entrydate = '$date'";
$result = mysql_query($sqlquery); 
$numbercases = mysql_numrows($result); 

echo "<span class='numcases'> Today there are $numbercases cases.</span>";

[galvin]

awesome thank you !!!!