Skip to content

Instantly share code, notes, and snippets.

@thotbox

thotbox/ExpressionEngine: Query Count.html

Last active August 29, 2015 14:02
Show Gist options
  • Save thotbox/f0b5c8bb3c3fc11f0499 to your computer and use it in GitHub Desktop.
Save thotbox/f0b5c8bb3c3fc11f0499 to your computer and use it in GitHub Desktop.
Download ZIP
ExpressionEngine: Query Count
Raw
ExpressionEngine: Query Count.html
{exp:query sql="SELECT COUNT(*) FROM exp_freeform_form_entries_2"}
<p><strong>Total Entries</strong> - {COUNT(*)}</p>
{/exp:query}
{exp:query sql="SELECT COUNT(*) FROM exp_freeform_form_entries_2 WHERE form_field_10 = 'Yes' OR form_field_11 = 'Yes' "}
<p><strong>Bonus Entries</strong>* - {COUNT(*)}</p>
{/exp:query}
{exp:query sql="SELECT COUNT(*) FROM exp_freeform_form_entries_2 WHERE form_field_10 = 'Yes' "}
<p><strong>Facebook Shares</strong>** - {COUNT(*)}</p>
{/exp:query}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment