Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Search in a particular range of dates

Quote Reply
Search in a particular range of dates
I'm thinking how to realize a mod that allow me to search let's say... all links dated from 1-jan-2000 to 30-jan-2000.

Should be I think a pretty nice inplementation to add in the search routine but I can't figure how to do that.

also, should work also if the query is empty to allow people to search all records inserted in a certain period.

Does anybody can help me?


cheers


lepo
Quote Reply
Re: Search in a particular range of dates In reply to
It shouldn't be too hard. It's just passing a parameter to the search routine, such that:

WHERE Date_Added > $start_date AND Date_Added < $end_date

Where "start_date" and "end_date" are form tags passed to the search.cgi.

By adding a couple of IF's to the search.cgi you could test for the $start_date and $end_date and put together the query you'd want.

It's late, and this is not guaranteed to work as written Smile But that's how you'd go about doing it....


------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/