monthly archives

why_not2

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

NogDog

Perhaps something like:

<?php
$sql = "
SELECT UNIQUE
   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>

why_not2

not worked 🙁

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource . . . . . . . . . . . .

NogDog

why not;10902352 wrote:

not worked 🙁

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource . . . . . . . . . . . .

Did you replace the table and column names with the actual names?

Also, I forgot to include the implode() I meant to use, and will edit my first response right after I submit this.

PS: You can help yourself debug the code by executing some code to check the result of the query:

$result = mysql_query($sql); 
if($result == false)
{
   user_error("Query failed: " . mysql_error() . "<br />\n$sql");
}

why_not2

Notice: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIQUE MONTH(`posted_date`) AS `mo`, YEAR(`posted_date`) AS `yr` FRO' at line 1
SELECT UNIQUE MONTH(`posted_date`) AS `mo`, YEAR(`posted_date`) AS `yr` FROM `article` ORDER BY `yr` DESC, `mo` DESC in . . . . . . . .

NogDog

Oops, my bad: UNIQUE should be DISTINCT. :o

why_not2

again error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in

my method code is ( EXAMPLE )

function get_cats(){
		global $DB, $Func, $HomeGlobal;

	$where_sql		= sizeof($HomeGlobal->di_cats) ? " WHERE id NOT IN (". implode(",", $HomeGlobal->di_cats) .")" : "";
	$DB->query("SELECT * FROM ". $DB->prefix ."news ". $where_sql ." ORDER BY cat ASC");
	$this->cat_count = $DB->num_rows();
	$this->cat_data  = $DB->fetch_all_array();
	$DB->free_result();
}

change your code to this method ??

why_not2

NogDog

any idea ?

why_not2

NogDog

thanks for help . my posted date was false :o. now fix this and nice worked 100% .
how to add day ?
example : show in dropdown :
July 2008
1
2
3
8
9
27
29
March 2008
7
8
15
........
archive by date/month/year

thanks alot man .