monthly archives

[Why_not]

hi !
how to creat list or dropdown menu list for monthly archives using php/mysql ?
EXAMPLE :
MARCH 2008
FEBRUARY 2008
APRIL 2008
MAY 2008
.
.
.
.
................
Now if any month not have data . NOTE : not show in list .
thanks regards

[tbarbedo]

$rs = mysql_query("query here");

echo '<select name="blah">';

while ($row = mysql_fetch_assoc($rs))
{
printf('<option value="%s">%s</option>', $row['columnname'], $row['columnname']);
}

echo '</select>';