I'm new here, and new in PHP... I'm trying to build a Resume Database Management Website, Where i can enter all candidates recode with my designed form on DB, And my client can search candidate with my given drop list , and keywords.
But my problem how can i search with multiple fields?
In my Database there are 2 types of Resumes recode
1 is normal resumes (who don't have any reference) ((in Database table name "data"))
2 is reference resumes (who have some body reference)((in Database table name "special"))
I want if my client want to search reference resumes then he first select radio button and then search with dropdown and the result will shown in search page. also i need same search engine in Search result page.
Can anyone help me
I have attached my php files and database schema
Please help me its very urgent.