query probs

[csniffer]

hi all,
i have this query but i want to take it one step further by searching 3 extra fields in the same table called jobchoice1, jobchoice2, jobchoice3, how can i expand the WHERE. Would it be something like: WHERE (town = '$town') AND (field1 = '$somevar' or field2 = '$somevar' of field3 = '$somevar');
this what i have at the moment

$query = "SELECT firstname, lastname, emailaddress, town from studentdetails WHERE town = '$town'";

i have tried this but it does not work, could some point out whare i am going wrong

To err is human, to completely mess up takes a computer.

 

[swampBoogie]

Using

WHERE (town = '$town') AND (field1 = '$somevar' or field2 = '$somevar' of field3 = '$somevar')

should work. What's the problem?

 

[csniffer]

thx i will double check my punctuation

To err is human, to completely mess up takes a computer.