How to make PHP & MySQL advance search ?

[plodos]

CREATE TABLE IF NOT EXISTS `conference` (
  `id` int(11) NOT NULL auto_increment,
  `year` varchar(10) NOT NULL,
  `mounth` varchar(20) NOT NULL,
  `country` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `name` text NOT NULL,
  `sname` varchar(50) NOT NULL COMMENT ,
  `keywords` longtext NOT NULL,
  `cdate` varchar(50) NOT NULL COMMENT ,
  `link` text NOT NULL,
  `rdate` datetime NOT NULL COMMENT ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=168 ;

 

I want to make advance search with using PHP.

 

1) There will be combobox for select conference year

2) After user will select month

3) maybe user will select onyl city, than user willl see the conferecences which are related with this city

4) or user can only search with keywords to see the related conferences

 

there are the conditions...

 

Could you give me an idea or sample code.

 

Thanks for everything.

[Boo-urns]

So what is mandatory for the search form?

 

Basically what you'll need to do is setup checks when you parse the data inputted. And set up a search based on that.