Reply To: sql query to get all members in a category

@ sean

First a question … is there a specific reason you writing you’re own query rather that using the shortcode?

This shortcode should do the trick:
[connections list_type='organization' category='3']

If you need the more low level access, you can do this within PHP like so:`global $connections;

$atts = array(
'list_type' => 'organization',
'category' => 3
);

$results = $connections->retrieve->entries( $atts );`

The you iterate thru the $results array.

If you want to take a look at the actual query being built so you can tweak a custom one to suit, open up the class.retrieve.php and uncomment line 768 which should be print_r($sql); die;

Hope that helps.