[SOLVED] PHP sql query

[monkeybidz]

I have this query:

 

"SELECT * FROM sb_members WHERE sb_gender=1 order by sb_id desc";

 

Is it possible to have the query select sb_gender if it =1, 2,or 3?

 

Would it be something like this?

"SELECT * FROM sb_members WHERE sb_gender=1,2,3 order by sb_id desc";

 

No clue! ???

[monkeybidz]

Got it, i used this:

"SELECT * FROM sb_members WHERE sb_gender=1 or sb_gender=2 or sb_gender=3 order by sb_id desc";

 

 

[monkeybidz]

Seems it only worked in some pages, but not in others.

How can i do so that:

sb_gender = 1 2 or 3?

 

[lightningstrike]

SELECT * FROM sb_members WHERE sb_gender IN ('1','2','3') ORDER BY sb_id DESC

 

should do what you want.

[monkeybidz]

Outstanding, It works great. What would i do without you guys.

Thanks a million!