Title: Query Total Points
Last modified: January 25, 2017

---

# Query Total Points

 *  [bc.ryan](https://wordpress.org/support/users/bcryan/)
 * (@bcryan)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/query-total-points/)
 * I’m looking for a way to query the total points for a particular team. We have
   a form so that people can sponsor goals and enter how much money they want to
   sponsor per goal. This is all setup and working. However, I need to be able to
   query how many total goals a team has scored so I can multiply that by the sum
   of the sponsored amount.
 * Any help would be greatly appreciated!

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Roch](https://wordpress.org/support/users/rochesterj/)
 * (@rochesterj)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/query-total-points/#post-8699762)
 * Hi!
 * Thanks for reaching out!
 * The easiest way I can think of is creating a parenty category for all of your
   competitions and then create a league table for the parent competition. So this
   parent competition will contain all the others 🙂
 * Kind Regards,
    -Roch
 *  Thread Starter [bc.ryan](https://wordpress.org/support/users/bcryan/)
 * (@bcryan)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/query-total-points/#post-8699863)
 * I don’t follow. I mean, I understand what you’re saying, but how will that help
   me query the points? To clarify, I’m looking to write this query in PHP code 
   so I can apply logic as opposed to just displaying something on the page.
 *  [Roch](https://wordpress.org/support/users/rochesterj/)
 * (@rochesterj)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/query-total-points/#post-8703992)
 * Hi!
 * That would help you displaying the total points in a page, it won’t help you 
   querying it indeed. You may use that with a shortcode or search for the functions
   we use for these outputs and have your query based on that.
 * Unfortunately you’ll need more custom code than we can provide.
 * Kind Regards,
    -Roch

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Query Total Points’ is closed to new replies.

 * ![](https://ps.w.org/sportspress/assets/icon-256x256.png?rev=1252005)
 * [SportsPress - Sports Club & League Manager](https://wordpress.org/plugins/sportspress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/sportspress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/sportspress/)
 * [Active Topics](https://wordpress.org/support/plugin/sportspress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/sportspress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/sportspress/reviews/)

## Tags

 * [goals](https://wordpress.org/support/topic-tag/goals/)
 * [League Tables](https://wordpress.org/support/topic-tag/league-tables/)

 * 3 replies
 * 2 participants
 * Last reply from: [Roch](https://wordpress.org/support/users/rochesterj/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/query-total-points/#post-8703992)
 * Status: not resolved