Order by month query

[monkeybidz]

I am trying to order by a certain month only, say January for instance. The current script calls all months available in database. Below is a part of the code i need help with.
[code]
$query = "SELECT a.starts FROM NAMEOFMYDATABASE_problem a WHERE
            a.starts=starts ORDER BY a.starts ASC limit $offset, $limit";
            $result = mysql_query($query);
            $tmp_date = mysql_result($result,$i,"a.starts");
            $month = substr($tmp_date,4,2);
            $day = substr($tmp_date,6,2);
            $year = substr($tmp_date,0,4);
            $date = "$month/$day/$year";
[/code]

What can i do to order data for january only since it uses a substr temp date?

Thanks in advance.

[radox]

just change your query to grab the month you need.

ie. for January

SELECT a.starts FROM NAMEOFMYDATABASE_problem a WHERE
a.starts=starts AND MONTH(a.starts)='1' ORDER BY a.starts ASC limit $offset, $limit

[monkeybidz]

Thanks so much! I have been trying this for months, but through other methods that did not do what i wanted. It works just like i want now. I made a few more modifications, but it works.

Thanks again!