hi !
write nice code in this page :
http://www.phpbuilder.com/board/showthread.php?p=10902328
<?php
$sql = "
SELECT DISTINCT
MONTH(`date`) AS `mo`,
YEAR(`date`) AS `yr`
FROM `table_name`
ORDER BY `yr` DESC, `mo` DESC
";
$result = mysql_query($sql);
$selectOptions = array();
while($row = mysql_fetch_assoc($result))
{
$selectOptions[] = sprintf(
"<option value='%04d-%02d'>%s %04d</option>\n",
$row['yr'],
$row['mo'],
date('F', mktime(0,0,0,$row['mo'],1,$row['yr'])),
$row['yr']
);
}
?>
...
<select name="archive">
<?php echo implode("\n", $selectOptions); // added implode() here ?>
</select>
this worked nice but I have two problem ! my date is hijri . for convert gregorian to hijri i change date to Hdate .
e.g :
<?PHP> echo Hdate("Y m d"); // Display 1404/01/01 hijri date ?>
for this archive script i change date to Hdate but only convert month rto hijri month . years not work . how to fix this ?
2 - how to show count data for each month . e.g : 02/2006 ( 45 )
thanks
