Double query results

Anon

I'm in need of a bit of help here. I have a mysql query as follows. First don't laugh at this query - we all got to start some where!!!!!

Anyway, here's my query. I'm getting doubles of each name it brings up and not really sure why. Hope you can give me a hint on how to fix this.

$query = "SELECT CFirstName,CLastName,CEmail,CCity
FROM clients,interests
WHERE (I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests')
OR CCity LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CPicture LIKE '$C%%%'
OR CEyeColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CHairColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CKids LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CBody LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CEducation LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CChurch LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
ORDER BY CCity, CLastName
";

brandonschnell

do you have names stored in clients AND in interests?

also it doesn't look like you're joining the two databases. in which case it'll pull back the name and client info along with any interests that match for any client.

if you have a unique key in both tables use that to join them and get just the interests for each client

query = "SELECT CFirstName,CLastName,CEmail,CCity
FROM clients,interests
WHERE (I1 = '$Interests' OR I2 = '$Interests' OR I3 = '$Interests' OR I4 = '$Interests' OR I5 = '$Interests' OR I6 = '$Interests' OR I7 = '$Interests')
OR CCity LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CPicture LIKE '$C%%%'
OR CEyeColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CHairColor LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CKids LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CBody LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CEducation LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
OR CChurch LIKE '$C%%%%%%%%%%%%%%%%%%%%%'
AND clients.id = interests.id
ORDER BY CCity, CLastName
";