I am designing a system wherein a student can search projects based on technology, project type, location etc etc.
The search form goes like this :-
Project Type - HTML Select Option - Example:- Automobile, Manufacturing, Marketing, Communication
Technology - Text Input Type - Example:- HTML, CSS, Java
Starting Year - HTML Select Option - Example:- 2002, 2003, 2010
Financing_type - HTML Select Option - Example:- Self Financing, Government Grants
Location - Text Input Type - Example:- New York, Tokyo, Bangalore
Technology and Location search fields are text fields and the user can give multiple technologies and multiple location seperated by comma.
The database has three tables:-
Project Table has the following columns:-
I am not sure how to make the search script as there are multiple tables involved + technologies and location can be more than one (i.e seperated by comma) - so the search becomes a bit more complex.