Problem with select query

Anon

Hello I have the following query which works great when I pass the CaseNo to it......

$query="Select case.CaseNo,case.CaseName,case.DateFiled,case.DateTermed, case.DateReopen,judge.Initials,party.PartyName,party.PartyType from case, judge, party
where CaseNo like '$CaseNo%'and aocode=judge.ao_code and CaseNo=party.CaseNum";

However when I try to use an or stament to allow the user to put in an initial or partyname to search the page hang's and then timeout....

$query="Select case.CaseNo,case.CaseName,case.DateFiled,case.DateTermed, case.DateReopen,judge.Initials,party.PartyName,party.PartyType from case, judge, party
where CaseNo like '$CaseNo%' or initials like '$initials%' or like '$partyname%' and aocode=judge.ao_code and CaseNo=party.CaseNum";

I assume my or statment is not correct if it works fine in the first example if someone could explain what is wrong that would be great.....

Anon

First, you're not specifying the tables in your where clause. You need to specify table.field in all clauses if you are joining tables.

Second "initials like '$initials%' or like '$partyname%'" has no meaning as you didn't specify the table.field that you wish to compare to '$partname%'. If you want to use the same field you'll need to specify that.