Help Needed

[ChrisBaktis]

Does anyone know a way to take the numerical value of a custom profile field of all the members and add them up and print it out?

[ChrisBaktis]

anyone?

[Marco van Herwaarden]

[sql]SELECT SUM(fieldx) from userfield[/sql]

[ChrisBaktis]

Is there a way for this total to show on one of my pages on the site (home page for example)?

[Marco van Herwaarden]

On any vB powered page (script) you could add a:

PHP Code:

$sum_userfield = $DB_site->query("SELECT SUM(fieldx) FROM " . TABLE_PREFIX . "userfield"); 


Now you can use $sum_userfield in your template or echo it out on another way.

[ChrisBaktis]

in a template would I just need to put '$sum_suerfield' where I want it to show up or do I need to use something like $post?

[Marco van Herwaarden]

If you make sure the above code is in the script that evaluate the template, and that it is executed before the template is called, then yes.

[ChrisBaktis]

Sorry to be a pain but yes to which one - using $sum_userfield by itself or using it like $post[sum_userfield] ?

My plans for now (while the board is smaller) to put this in the Navigational Bar - I will add your code to the global.php file. Can you tell me what I would need to use based on that info?

Anyone?

[Marco van Herwaarden]

Change that query to:

PHP Code:

$sum_userfield = $DB_site->query_first("SELECT SUM(fieldx) as total FROM " . TABLE_PREFIX . "userfield"); 


Then use $sum_userfield[total] in your template.

[ChrisBaktis]

Thanks!