Jump to content

Display My SQL query when link is clicked


Recommended Posts

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/




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;

        $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">';

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

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

    return $statelinks1;

 add_shortcode('memberlist', 'listMembers');

function listRescueStandards() {

    $display_members = '';
    $sql = mysql_query("SELECT vc.*, s.*, 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 = "";

            $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 by mfulling
Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.