multiple parameters in query string

This is probably basic, but I'm blacking out.

Say I have a string of code:

("SELECT * FROM mytable WHERE Type='Type1' ORDER by $order")

What If I need to get results for more then one Type? Would it be something like this:

("SELECT * FROM mytable WHERE Type='Type1' AND Type='Type2' ORDER by $order")

("SELECT * FROM mytable WHERE Type='Type1, Type2' ORDER by $order")

"SELECT * FROM mytable WHERE Type='Type1' OR Type='Type2' ORDER by $order"

or a better method would be:

"SELECT * FROM mytable WHERE FIELD(Type,'Type1','Type2')ORDER by $order"

I am assuming u meant OR instead of AND, because with the AND it did not make any sense. It was always going to return an empty set.

Well, like I said I blacked out. I put AND because I need both and not either OR.

I think the second method you suggest looks like a winner. Let me give it a whirl!

Thanks!

HUH!! How can TYPE be equal to "TYPE1" and "TYPE2" at the same time??

Works great! Quite elegant too.