Display My SQL query when link is clicked

[mfulling]

I have a "Members" page that displays my organizations members info via My SQL. Currently, the database displays "State" quick links at the top and has the members organized by State down the page. If you click on one of the State links at the top, it will navigate to the section of the page with that state and associated members. I want the members associated with a specific state to be displayed only once I click the associated state link -- instead of all of the information showing at once like it is now. The page I am referring to can be seen at this link: http://homesforhorses.dreamhosters.com/members/

<?php

update_option('image_default_link_type','none');

include("/home/cingen/config_admin.php");


function listMembers() {

    $sql = mysql_query("SELECT c.*, s.*
	    FROM (".TABLE_MEMBERS." c LEFT JOIN ".TABLE_STATE." s on c.state = s.state_abbr)
        WHERE c. status = '1'
	    ORDER BY c.country, c.state, c.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
        $display_members = false;

    	$organization = stripslashes($row['organization']);
	    $website = stripslashes($row['website']);

    	if ($website) {
	    	$link = "<a href='http://".$website."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    $display_members .= $link.$organization.$endlink."<br />";

    	if ($row['address'])    $display_members .= stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />";
        if ($row['city'])       $display_members .= stripslashes($row['city']).", ";
        if ($row['state'])      $display_members .= stripslashes($row['state'])."";
        if ($row['zip'])        $display_members .= "  ".$row['zip'];

        $display_members .= "<br />";

    	if ($row['contact_name'])       $display_members .= "Contact: ".stripslashes($row['contact_name']);
	    if ($row['contact_title'])      $display_members .= ", ".stripslashes($row['contact_title']);
    	if ($row['phone']) 	    	    $display_members .= "<br />Tel: ".stripslashes($row['phone']);
	    if ($row['email']) 		        $display_members .= "<br />".$row['email'];
	    if ($row['website']) 	        $display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a><br/>";
	    if ($row['year_est'])           $display_members .= "Founded in ".$row['year_est'].".";
		if ($row['org501c3'] == "1")    $display_members .= " A 501(c)3 non-profit.";
	    if ($row['gfas'] == "1")   		$display_members .= "<br />GFAS: Accredited Sanctuary.";
	    if ($row['gfas'] == "2")        $display_members .= "<br />GFAS: Verified Sanctuary.";
		if ($row['member_category'])    $display_members .= "<br />".$row['member_category'];

      $display_members .= "<br /><br />";

      $entries[$row['country']][$row['state_name']][] = $display_members;
    }

    $countrylinks = false;
    $statelinks   = false;
    $display      = false;



    if(is_array($entries)){
        $display .= '
        <div class="memberlist">';
        foreach($entries as $country=>$state_members){
            $countrylinks .= '<a href="#'.$country.'">'.$country.'</a>    ';

            $display .= '
            <h2 id="'.$country.'">'.strtoupper($country).'</h2>
            <div class="country">';


            if(($state_members)){
                foreach($state_members as $state=>$members){
                   $statelinks .= '<a href="#'.$state.'">'.$state.'</a> ';

                    $display .= '
                    <h3 id="'.$state.'">'.strtoupper($state).'</h3>
                    <div class="state">';
                    if(is_array($members)){
                        foreach($members as $key=>$member){
                            $display .= '
                            <div class="member">
                                '.$member.'
                            </div>';
                        }
                    }
                    $display .= '
                    </div>';
                }
            }
            $display .= '
            </div>';
        }
        $display .= '
        </div>';
    }
    $statelinks1 = '
    <h2>Members List</h2>
    <strong>Quick Links</strong><br /><br />
    '.$statelinks.'<br /><br />'
    .$display;


    return $statelinks1;
}



 add_shortcode('memberlist', 'listMembers');


function listRescueStandards() {

    $display_members = '';
    $sql = mysql_query("SELECT vc.*, s.*, m.*
	    FROM ".TABLE_COMPLIANCE." vc, ".TABLE_STATE." s, ".TABLE_MEMBERS." m
    	WHERE vc.member_id = m.cid
	    AND m.status = '1'
    	AND m.state = s.state_abbr
	    ORDER BY m.state, m.organization ASC");

    while ($row = mysql_fetch_array($sql)) {
	    $organization = stripslashes($row['organization']);

    	if ($row['website']) {
	    	$link = "<a href='http://".$row['website']."' target='_blank'>";
		    $endlink = "</a>";
    	} else {
	    	$link = "";
		    $endlink = "";
    	}

	    if($x!=$row['state_name']){
            $display_members .= "<br /><strong>".strtoupper($row['state_name'])."</strong><br />";
            $x = $row['state_name'];
        }

    	$display_members .= $link.$organization.$endlink."<br />
	       ".stripslashes($row['address'])." ".stripslashes($row['address2'])."<br />
    	   ".stripslashes($row['city']).", ".stripslashes($row['state'])."  ".$row['zip']."<br />";

	    if ($row['contact_name']) $display_members .= "Contact: ".stripslashes($row['contact_name']);
    	if ($row['contact_title']) 	$display_members .= ", ".stripslashes($row['contact_title']);
	    if ($row['phone']) 		$display_members .= "<br />Tel: ".stripslashes($row['phone']);
    	if ($row['fax']) 	$display_members .= "<br />Fax: ".stripslashes($row['fax']);
	    if ($row['email']) 	$display_members .= "<br />".$row['email'];
    	if ($row['website']) 		$display_members .= "<br /><a href='http://".$row['website']."' target='_blank'>".$row['website']."</a>";
	    if ($row['year_est']) 		$display_members .= "<br />Founded in ".$row['year_est'].".";
    	if ($row['org501c3'] == "1") 		$display_members .= "<br />This organization IS registered with the IRS as a 501(c)3.";
        if ($row['org501c3'] != "1") 	$display_members .= "<br />This organization is NOT registered with the IRS as a 501(c)3.";

    	$display_members .= "<br /><br />";
    }

            return "<div class='memberlist'>" . $display_members . "</div>";

}
add_shortcode('standardslist', 'listRescueStandards');

 

Thank you in advanced for your help! I am grateful for anyone even looking at it.

Edited October 10, 2014 by mfulling