PHP - Moved: Joomla 1.6 Search Finish Publishing Date

Hi Friends.....
I want to implement search indexing (like joomla) in my website. Earlier I develop search from database by "select" statement. But for whole website, I don't have any idea to do it............
Plzzzzzzz Help ??????///
I'll highly oblized to you.............

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=306933.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=314053.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=328109.0

I have a page where the user can search with dropdowns. Two of these are lists for year and month.

Month list is from 0-12, where 0 is all months, 01 is for january, 02 for february, and so on...

The year list have 0, 2011 and 2012 (so far, will expand as times go) where 0 is all years...

When I have made my query I have had


Code: [Select]
if($month == ''){$month = "";}
if($month == '0'){$month = " AND mytable.datum >= '2011-01-01' AND mytable.datum < '2012-01-01'";}
if($month == '1'){$month = " AND mytable.datum >= '2011-01-01' AND mytable.datum < '2011-02-01'";}
...
...
and

Code: [Select]
if($year == '0'){$year = " AND mytable.datum >= '1970-01-01' AND mytable.datum < '2050-01-01'";}
if($year == '2010'){$year = " AND mytable.datum >= '2010-01-01' AND mytable.datum < '2011-01-01'";}
...
...

manually coding...

Now I want it to be more dynamic:)

But I am stuck

Anybody have any ideas on how to make my query more dunamic??

Thanx in advance