Date Question

[tmurphy]

I have a table in my database call hbday the format is as follows YYYY-MM-DD. What I need to do is pull up birthdays in a specified range. MM-DD through MM-DD The years is not important. The question is, how do i have Mqsql show me the date range and ignore the year? Here is the code i have so far:

$startdate = (date ('m-d',strtotime ("1985-$month-$day")));
$enddate = (date ('m-d',strtotime ("1985-$smonth-$sday")));

$query = "SELECT * FROM contacts WHERE hbday = '$startdate <= $enddate'";
$result = @($query,$connection) or die("Couldn't execute query.");

[bernouli]

try this

$startdate = 1;
$enddate = 10;

$startmonth = 1;
$endmonth = 10;
$query = " SELECT * FROM contacts 
                    WHERE (
                        (DAYOFMONTH(hbday) BETWEEN ".$startdate." AND ".$enddate.") 
                     AND 
                         (MONTH(hbday) BETWEEN ".$startmonth." AND ".$endmonth.")) ";