I have a custom field (numeric), I want to show the total value from all users in my website header.
SQL to get the total (which works) is
SUM(field_value) as MyTotal
WHERE field_id = 0x4B6472486F6C64696E67
so um, what next - I'm hoping there is a simple few lines of PHP I can dump in the appropriate template.
thanks for even reading this far