think tank forum

Piss, trying to combine the two datasets into a single array is nonscalar. Who knew a poll was so fucking difficult?

SELECT poll.PollOption1, poll.PollOption2, poll.PollOption3, poll.PollOption4, poll.PollOption5 from poll where poll.PollId=1
UNION
SELECT(SELECT COUNT(*) FROM votes, poll WHERE votes.VoteValue = poll.PollOption1 AND votes.PollId=poll.PollID),
(SELECT COUNT(*) FROM votes, poll WHERE votes.VoteValue = poll.PollOption2 AND votes.PollId=poll.PollID),
(SELECT COUNT(*) FROM votes, poll WHERE votes.VoteValue = poll.PollOption3 AND votes.PollId=poll.PollID),
(SELECT COUNT(*) FROM votes, poll WHERE votes.VoteValue = poll.PollOption4 AND votes.PollId=poll.PollID),
(SELECT COUNT(*) FROM votes, poll WHERE votes.VoteValue = poll.PollOption5 AND votes.PollId=poll.PollID) from votes where votes.PollId=1

post schemas and what you want

It's resolved

mat you rule at posting sql problems then resolving them yourself

Haha, I always get so flustered when shit doesn't work that I copy and paste things into here hoping someone is online. After I smoke, I usually have a pretty good idea what the problem was. So smoke up kiddies, and your problems with be fixed!

^ Weed?

i think hes talking about cigarettes