Segment Top Teams into two display tables - database query

Mark Haynes

 We've created an event site in Sphere (still in preview at this time). By default there is a table that displays top teams, so obviously there is a query that returns this data for display on the page. In the registration form for Team Registration we've set up a custom profile field so the registrant can specify whether his team represents a large corporation/organization or a small corporation/organization using a radio button set. Apparently the value that is passed is the label used for the selected company size.

I've downloaded the KinteraConnect.wsdl and the nusoap-0.7.2 libraries following the steps in the Sphere Connect API documentation and I've viewed some sample files as well as some of the PHP sample code, replacing the 'LoginName' and 'Password' with my Sphere login name and password using the PHP code in my PHP testing server. When I view my test page I don't get any errors but the values are not displayed, just the labels.

Other than the login information, what else is needed to connect to the database and run a query against it?

How do I find the proper query syntax to return my top 5 teams?

How do I filter the query to return the top large corporate teams in one query and the top small corporate teams in another query?

Thanks in advance for any help you can provide!