An impossible mySQL Query

[John_S]

Greetings!

 

 

Recently I've been reading some php articles, and I found one with an interesting script concept but with an impossibly huge MySQL query which doesn't seem to work, unfortunately complicated MySQL queries aren't my cup of tea, so I wasn't able to fix it, that's why I am here hoping that somebody could help me to solve it.

 

 

SELECT options.id, options.value, COUNT(*) AS votes FROM votes, 
FROM 'options' 
WHERE options.id = votes.option_id AND votes.option_id IN(SELECT id FROM options WHERE ques_id='1') 
GROUP BY votes.option_id

 

 

Thank you a lot in advance!

John_S

[kickstart]

Hi

 

Something like this would do it

 

SELECT b.id, b.value, COUNT(*) AS votes 
FROM votes a
INNER JOIN options b ON a.option_id = b.id
WHERE b.ques_id='1'
GROUP BY a.option_id

 

All the best

 

Keith

[John_S]

Thank you!

Worked like a charm!