Textpattern CMS

#1 2011-07-20 08:23:59

Manaus

Member

From: Turin, Italy

Registered: 2010-10-22

Posts: 252

Website

Search by month?

Hello, I need to perform a query like this:

Select * from articles 
where month = month(now())

Is this doable?

Thanks

#2 2011-07-20 10:38:02

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: Search by month?

I’m sure this one helps :)

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2011-07-21 15:40:25

frickinmuck

Member

Registered: 2008-05-01

Posts: 118

Re: Search by month?

This may help you.

http://txptips.com/news-archive-using-a-pulldown-list

All you really need is the pulldown menu, and away you go.

---

^{The AI does not hate you, nor does it love you, but you are made out of atoms which it can use for something else.}