Jump to content

Archived

This topic is now archived and is closed to further replies.

monkeybidz

Order by month query

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.