Search Engine Problem ( Please Urgently Solve )

[segiboy]

Dear Friend,

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.

Regards.
Farhan..

[mohan7690]

hi farhan,

user selecting the radio button?

if user is selected normail resume then compare in the data table,

if user is selected reference resumes then compare in the special table.

based on the choice execute 2 difference query's and return the result

[segiboy]

hi farhan,

user selecting the radio button?

if user is selected normail resume then compare in the data table,

if user is selected reference resumes then compare in the special table.

based on the choice execute 2 difference query's and return the result

Hi Mohan,

thanks for reply,

Yes i mean to say if user select normal resumes check box then result will pick from data table,

or user select special resumes check box then pick from special.

***************************************************************
(Process of searching)
------------------------

1- Selection of radio button (special or normal resumes)
2- Select from Keyword
Or
3- Selection of drop down menu
4- Result will shown on search.php (in result page same search engine will show below the dear)

***************************************************************
Could you please help me dear? Can u change the update the query my attached project?

Waiting for your reply.

Thanks

[segiboy]

Please somebody reply me its very urgent

[segiboy]

Still waiting for reply :(

[vaibhav1983]

You can set a colum in db where you can insert value as N for Normal and S for Special.

When you search for resumes, in the weher clause put an and clause.

Keeping two tables for the same data is not good. You will reduce the performance of your application. Moreover its not good database designing.