Comparing date

[newbieiguess]

Hi i want to compare a date stored on a mysql table and the actual date to see if they are the same, if true, delete the data am using this:

---

$now = date('Y-m-d');

$result = mysql_query ("SELECT * FROM table WHERE date='$now'") or
die (mysql_error());
while ($row = mysql_fetch_array($result))
{
result = mysql_query("DELETE FROM table");

}

The date is stored as:
year-month-day
example:
2005-05-28

the date stored is on a field called 'date' on the table which in this case is named 'table'

thanks for the help.

[owens]

You can just write as below

$now = date('Y-m-d');
$result = mysql_query ("Delete FROM student WHERE dob='$now'") or
die (mysql_error());

It deletes all the records with the current date.