Some of the features which I initially planned that didn't make it are:
- Limit ads to 30 days
- Registration free
- E-mail reminders
The code for pagination is relatively simple.
@classified_pages, @classifieds = paginate :classifieds,
:order => 'post_date DESC',
:per_page => 15,
:conditions => '( CURDATE() - classifieds.post_date)<30'
I avoided that from the start because I didn't want to tied the condition to MySQL's CURDATE(). Well I guess I'll be pragmatic about it and do what works for me now.
The condition above actually translated to:
SELECT (*) FROM classifieds
WHERE ( CURDATE() - classifieds.post_date)<30>