Per one of the FAQ's, I made the appropriate changes to sub_query in db.cgi, but Im at a loss on how to actually search for what I need.
I need to have a drop down box that says "Search all ads with a requested date of" = Jan, Feb, March, etc.. The actual date requested field is a full date like 1/1/2002, but I only need it to pull the month part of the date.
But I have no idea how to make it search. I tried making a select name="Dates1" with option values of 1,2,3, etc. for the month part of the date, but it didnt work. I have a another drop down search of the date posted field by how old an ad is (1 week, 2 weeks, etc.), but that is configured with the get_date sub, and I dont think that will work with just searching on part of the dates1 field.
Obviously I cannot make a regular link with a statement of dates1=1 (for January) because it needs to be a drop down box instead of a link.
Can someone help me out?
I need to have a drop down box that says "Search all ads with a requested date of" = Jan, Feb, March, etc.. The actual date requested field is a full date like 1/1/2002, but I only need it to pull the month part of the date.
But I have no idea how to make it search. I tried making a select name="Dates1" with option values of 1,2,3, etc. for the month part of the date, but it didnt work. I have a another drop down search of the date posted field by how old an ad is (1 week, 2 weeks, etc.), but that is configured with the get_date sub, and I dont think that will work with just searching on part of the dates1 field.
Obviously I cannot make a regular link with a statement of dates1=1 (for January) because it needs to be a drop down box instead of a link.
Can someone help me out?
Confused over date search...