Need help with a special (?) search engine.

[Anon]

First I want to apologize for my bad english.
I want to create a php mysql search engine. It will be a cocktailrecipe search engine. The user has to insert the ingredients and the search engine just picks out the cocktails which contain no more than the selected ingredients.
This means i have to compare the selection and the content of the table. i do know how to compare the content of a table with a variable but i do not know how to compare the variable with the content of a table.

Thanx for your support

Michael (Germany)

[Anon]

Your english is fine, but your question is a bit strange.

What exactly do you need to compare?

[Anon]

For Example:
I want to compare a variable (the value is for example 100,101,102) with the content of several table columns.
So if the value of the first column is 100 the value of the second column is 101 and the value of the third column is 102, the search engine picks out the rows where this selection fits.
if the columns no.1 is 100 and the columns no.2 is 101 the row should also be shown.
But if the column no1 is 100 and the column no.2 is 101 but the column no.3 is 103 not!.
Easier:
So my search engine should go like this.
The visitor tells me which ingrediants he (or she) has in his bar and i will tell him which different cocktails he can mix.