Re: Newbie PHP MySQL percentage

Something like this below should do the job.

SELECT count(*) AS total_count
FROM poll_answers
WHERE poll_id = $poll_id


SELECT answer_id, ( count(*) * 100 / $total_count ) AS answers_percentage
FROM poll_answers
WHERE poll_id = $poll_id
GROUP BY answer_id

Hilarion