get list of months

[praethorian]

Hi, I'm creating my own weblog and I would like to have a list of months to have quick access to the archive. Something like this:

 

ARCHIVE:

November

September

August

 

I have my date saved in DB as timestamp. How can I create a query to get these months?

Thank you. P

[fenway]

You use MONTH(FROM_UNIXTIME( yourField ) )

[praethorian]

You use MONTH(FROM_UNIXTIME( yourField ) )

 

Hi, thx for your help, it point me to the right direction, but I got stuck. I dont know how to select data from the desired month.

 

For example: I choose september = 9 => $month = 9;

$month = $_GET["m"];
@$result = mysql_query("SELECT * FROM ".TBL_NAME." WHERE date = ??  ORDER BY date DESC") or die("Error: " . mysql_error());

 

I dont know how to select all posts from september, date is saved as timestamp.

Thx

[fenway]

You shouldn't use date as your column name, that's a reserved keyword....

$month = $_GET["m"];
$result = mysql_query("SELECT * FROM ".TBL_NAME." WHERE MONTH(FROM_UNIXTIME( `date` ) ) = '$month'  ORDER BY `date` DESC") or die("Error: " . mysql_error());