Mysql count query that calculates a total

Question

I am trying to modify a count query so I can the output onto a webpage. Current code is:

$db->setQuery("SELECT COUNT(`SubmissionId`) FROM #__forms WHERE FormId='8' ");

echo "So far we have <strong>".$db->loadResult()."</strong> submissions";

It works fine as it shows the number of submisisons where the value in the formid is 8. But I also want to include in the sum formid 4 and 5 so I have a combined total.

Any ideas?

MillaresRoo · Accepted Answer · 2013-12-15 17:14:09Z

1

Change your query for: "SELECT COUNT(SubmissionId) FROM #__forms WHERE FormId IN ('8','4','5')"

answered Dec 15, 2013 at 17:14

MillaresRoo

3,8581 gold badge35 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3104919 Over a year ago

You know what, I had been trying the IN option but for some reason I must had missed something. Now working.

klarki · Accepted Answer · 2013-12-15 17:14:50Z

0

try this query:

"SELECT COUNT(SubmissionId) FROM #__forms WHERE FormId='8' OR FormId='4' OR FormId='5'"

answered Dec 15, 2013 at 17:14

klarki

9154 silver badges13 bronze badges

Collectives™ on Stack Overflow

Mysql count query that calculates a total

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related