query( $sql ) ) { date_default_timezone_set('America/New_York'); while ( $row = $res->fetch_object() ) { switch ($row->cb_region) { case "Carolinas": $region_link = "http://www.carolinasb2bcfo.com"; break; case "Houston": $region_link = "http://www.houstonb2bcfo.com"; break; case "Philadelphia": $region_link = "http://www.philadelphiab2bcfo.com"; break; case "Central States": $region_link = "http://www.centralstatesb2bcfo.com"; break; case "Indiana": $region_link = "http://www.indianab2bcfo.com"; break; case "Arizona": $region_link = "http://www.phoenixb2bcfo.com"; break; case "Chicagoland": $region_link = "http://www.chicagolandb2bcfo.com"; break; case "Metro NY/NJ": $region_link = "http://www.metronynjb2bcfo.com"; break; case "San Diego": $region_link = "http://www.sandiegob2bcfo.com"; break; case "Colorado": $region_link = "http://www.coloradob2bcfo.com"; break; case "Michigan": $region_link = "http://www.michiganb2bcfo.com"; break; case "PNW": $region_link = "http://www.pnwb2bcfo.com"; break; case "Connecticut": $region_link = "http://www.connecticutb2bcfo.com"; break; case "MidSouth": $region_link = "http://www.midsouthb2bcfo.com"; break; case "South Florida": $region_link = "http://www.southfloridab2bcfo.com"; break; case "DC": $region_link = "http://www.dcmetrob2bcfo.com"; break; case "Upper Midwest": $region_link = "http://www.uppermidwestb2bcfo.com/"; break; case "Southern California": $region_link = "http://www.southerncaliforniab2bcfo.com"; break; case "DFW": $region_link = "http://www.dfwb2bcfo.com"; break; case "Mountain States": $region_link = "http://www.mountainstatesb2bcfo.com"; break; case "Upstate NY": $region_link = "http://www.upstatenyb2bcfo.com"; break; case "Georgia": $region_link = "http://www.georgiab2bcfo.com"; break; case "New England": $region_link = "http://www.newenglandb2bcfo.com"; break; case "Western PA": $region_link = "http://www.westernpab2bcfo.com"; break; case "Gulf Coast": $region_link = "http://www.gulfcoastb2bcfo.com"; break; case "Northern California": $region_link = "http://www.northerncaliforniab2bcfo.com"; break; case "Wisconsin": $region_link = "http://www.wisconsinb2bcfo.com"; break; case "Ohio": $region_link = "http://www.ohiob2bcfo.com"; break; } $username = strstr($row->cb_email, '@', true); if ($username == "jerry") { $username = "jmills"; } $body .= "

"; $body .= "

" . $row->cb_displayname . "

"; $body .= "

" . $row->cb_region . "

"; } } ?> B2B CFO Certified Partners

B2B CFO® Certified Partners