Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Archive by Month Menu - blog style

Archive by Month Menu - blog style

Thread began 2/10/2012 3:03 am by Daryl | Last modified 5/08/2012 11:19 am by Daryl | 7422 views | 23 replies

2/10/2012 9:00 amJason ByrnesWebAssist

you would need a recordset to query the blog table for the date posted, then use the recordset to populate your menu.

something like:

SELECT Date_format(dateposted, '%M, %Y'),
FROM blog_entries
GROUP BY YEAR(dateposted),
MONTH(dateposted)
ORDER dateposted DESC

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.