complex if statement search

[Anon]

i'm trying to put together a search of my product database. The user can input into a form to inputs. (side1 and side2). I have a DB that has the following columns:

dosage1, dosage2, dosage3, side1_1, side2_1, side1_2, side2_2, side1_3, side2_3, desciption1, description2, desciption3.

So I'm trying to take the input from the user and compare it like this:

if ((side1 = side1_1 or side2_1) or (side2 = side1_1 or side2_1)) OR if ((side1 = side1_2 or side2_2) or (side2 = side1_2 or side2_2)) OR if ((side1 = side1_3 or side2_3) or (side2 = side1_3 or side2_3))

Then i would like it to be able to out put the corresponding info such as if the info == side1_2 then output dosage2, descrption2.

Any ideas?

Sorry if i jumped around.

cs

[Anon]

Any chance you can re-design your database? Your tables are set up horribly. You should have 2 tables from the data above, and I'd bet there should even be a 3rd table that holds basic medication information.

[tomhath]

I second Rob's suggestion. What you have is an array inside each row; those are usually very hard to work with.