JOIN is duplicating my output

[Jaynesh]

Hello

 

I have two tables

 

Posts(post_id,user_id, post)

vote (vote_id, up, down)

 

Let's say I have 5 rows in post and 2 rows in vote.

 

If I execute this sql query, it will output all the posts that match the users id.

 

SELECT DISTINCT Posts.post, vote.user_id FROM Posts, vote WHERE Posts.user_id = $user";

 

If I execute this sql query, with a small addition(in red)

 

SELECT DISTINCT Posts.post, vote.user_id, vote.vote_id FROM Posts, vote WHERE Posts.user_id = $user";

 

It will output all the posts that match the users id multiplied by how many rows there are in the vote table. WHY IS THIS HAPPENING? 

[Psycho]

I'm not sure what you are trying to do, but I'm pretty sure you are doing it wrong. I don't see any relationship between your Posts table and your vote table. When joining two tables it will join every record from one table on every record from the other table - doing exactly what you described.

 

Is the vote_id supposed to be the foreign key for the post ID? Your table structure just doesn't make any sense.

[Jaynesh]

Hello

 

my vote_id assigns an incremented number to each row. I don't want that column to be joined however I want to output that column in my script.

 

How do I go about doing this?

[phpmady]

Hi,

 

Please Post your question in MYSQL section

 

Thanks,

 

 

 

 

[Psycho]

my vote_id assigns an incremented number to each row. I don't want that column to be joined however I want to output that column in my script.

 

If there is no relationship between the posts table and the votes table then you shouldn't try and pull results from both tables in one query. Although, I would assume there SHOULD be a relationship between the tables (i.e. the users vote on the posts?)

[Jaynesh]

Hello

 

I want to output the vote_id and use it in an if statement with another output from the query.

 

What is my alternative?

[Jaynesh]

sorry, I just realized that I am an idiot.

 

Thank you for your efforts.