Pages

Sunday, April 2, 2017

How to get Distinct Years using DATE_FORMAT() In the mysql database table

$rs =  mysql_query("SELECT DISTINCT(DATE_FORMAT(date_paid,'%Y') ) as mindate FROM purchase ORDER BY mindate ASC");
     
        ?>
       
        <select name="dy">
       <?php

       while( $minDate = mysql_fetch_array($rs) ) {
        $seldm = $_GET['dy'] == $minDate['mindate'] ? 'selected="selected"' : '';
        echo '<option value='.$minDate['mindate'].' '.$seldm. '>'.$minDate['mindate'].'</option>';
       }
       ?>
        </select>