reminder mail when date is within a month of today.

HI I'm having a bad thinking day. I know it's going to be a very easy solution, but please humour me. I have a mysql table with a bunch of subscribers and the date that they subscribed. I want to query the table to find all the subscribers who will come up for renewal within the current month. So, each time I access the page, it must generate a table with those who's subscription is going to expire in this month, as well as those who might already be past the renewal date. I can handle the generation of the table and all, I'm just not coping with the query string. Thanks