[devtalk] Retrieving monthly counts for multiple choice answers from MySQL for charting

Matt Wallace matthew at truthisfreedom.org.uk
Mon Jan 10 22:17:40 GMT 2011


That should of course be answers, not anders. 

Bloody auto correct. 

M

Matt Wallace <matthew at truthisfreedom.org.uk> wrote:

>Hey! :)
>
>Assuming you have a table called "answers" linked to a table called questions on a field named questionId then the following should work:
>
>Select count(answerId) from anders where questionId = $questionId
>
>Hth, 
>
>Matt


More information about the devtalk mailing list