not to sure how to go about doing this query...

[henricar]

Hey guys, here is what I'm trying to do:

 

I have a table width user data.

 

I have a table width posts from users.

 

I have a table with people's votes of the posts.

 

Can I get the number of people who voted for a post made by a particular user?

 

I could fetch all posts made by a certain user, but who do I "scan" for all votes using this array?

 

thanks!

[Maq]

Moving to SQL section.

[kickstart]

Hi

 

Something like the following would get you a count of all the votes for each post by each user:-

 

SELECT a.users_id, a.UserName, b.PostTitle, COUNT(c.Vote)
FROM users a
INNER JOIN posts b ON a.users_id = b.users_id
INNER JOIN votes c ON b.post_id = c.post_id
GROUP BY a.users_id, a.UserName, b.PostTitle

 

However not sure whether this is what you want, or whether you only care about one users posts.

 

All the best

 

Keith

[henricar]

hey thanks for the reply! sorry I took a while to answers but I've been studying for finals and I'm in over my head but what exactly do the a b c and do here?

[Pikachu2000]

They're aliases for the table names. users a, posts b, votes c . . .