Complicated MySQL query

[cosmoparty]

Does anyone know how do OR in a SELECT query? What I mean by this is:

SELECT * FROM profiles WHERE profiles.venue1='$number' OR profiles.venue2='$number'

This must return all results that have
1. $number in venue1 and whaterver in venue2
2. $number in venue2 and whaterver in venue1

For eg: it must return rows that have values in (venue1,venue2):
($number,52)
($number,$number)
($number,62)
(41,$number)

And if possible it should only return rows once (I think I enter DISTINCT somewhere).

Thanks for your help,

Christian

[sarahk]

and your problem is? you look like you have it sussed
possibly add

$sql = "SELECT distinct venue1+venue2 as dummystr, * FROM profiles WHERE profiles.venue1='$number' OR profiles.venue2='$number'";