Select distinct month or year
Here is MySQL syntax for select distinct month or year
SELECT distinct month(daterelease) as bulan FROM releases WHERE year(daterelease)=’$tahun’ AND sportsid=’$sportsid’ ORDER BY daterelease DESC
while ($releasemonthline = mysql_fetch_array($releasemonth)) {
$bulan=$releasemonthline["bulan"]; // get from “as bulan”
$bulan=$releasemonthline["bulan"]; // get from “as bulan”
}
Here is complete reference: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
This entry was posted on Thursday, August 12th, 2010 at 9:20 am and is filed under PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
