table joining multiple results problem

[OwenTheSamoan]

I want to join two tables. I'm using php with mysql.

$query = "SELECT * FROM table1, table2 WHERE table1.user_id = table2.user_id";

I get the desired results from the above query. Only problem is that I'm getting two or three duplicates of every result. If I would normally get one result, I am now getting two or three. Anyone know why I'm getting duplicates?

[tomhath]

The query looks okay. So the problem must elsewhere.

Either one of the tables contains multiple rows with the same user_id, or your code that displays the rows is printing the same row multiple times.

[OwenTheSamoan]

you're right. One of the tables did have multiple rows with the same userid. I added DISTINCT to the query and it works perfectly now. Thanks.