query($sql); $this_count = $result->size(); if($this_count>0){ include("inc_site_header.php"); //echo '

'; //echo "

"; $url_state_folder = str_replace(" ", "-", strtolower($geo_state)); $url_state_anchor = $geo_state; $url_city_folder = str_replace(" ", "-", strtolower($geo_city)); $url_city_anchor = $geo_city; $url_title_this = $url_title.' in '.$geo_city.', '.$geo_state; //without microdata //$url_this_topnav_product = ''.$brand_kw1.' Training'; //$url_this_topnav_title = ''.$url_title.''; //$url_this_topnav_state = ''.$url_state_anchor.''; //echo "
".$url_this_topnav_product." » ".$url_this_topnav_title." » ".$url_this_topnav_state." » ".$geo_city."
"; $url_div_breadcrumb_open = ''; $url_div_breadcrumb_close = ''; $url_div_breadcrumb_itemprop_open = ''; $url_div_breadcrumb_itemprop_close = ''; $url_this_topnav_product = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_title = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_state = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_city = $url_div_breadcrumb_open.''.$url_div_breadcrumb_close; //echo '
'.$url_this_topnav_product.' '.$url_this_topnav_title.' '.$url_this_topnav_state.' '.$url_this_topnav_city.'
'; echo '
'.$url_this_topnav_product.' '.$url_this_topnav_title.' '.$url_this_topnav_state.' '.$url_this_topnav_city.'
'; require_once('geo_lists_page.php'); //echo "
"; //echo '
'; include("inc_site_footer.php"); }else{ //city/state not found in the database - give them a 404 header('HTTP/1.0 404 Not Found'); include("404.php"); exit(); } }else{ if($geo_state!=""){ //locate state $geo_state = mysql_real_escape_string($geo_state); $sql = ''; $sql = 'SELECT state, abbr, city FROM geolist_major_state_abbr_city where state = "'.$geo_state.'" order by city asc'; $result = $db->query($sql); $this_count = $result->size(); if($this_count>0){ $state_found = 1; //$output_all = ''; $output_all = '
'; $this_count = 0; while($row = $result->fetch()) { if($this_count==0){ //$output_all .= '
'; $output_all .= '
'; $output_all .= '

'.$url_title.' in '.$geo_state.'

'; $output_all .= '

'.$geo_state.' '.$url_title.'. To find a '.$brand_kw1.' '.$learntype_arr[2].' in '.$geo_state.' please select a city in '.$geo_state.' ('.$row['abbr'].') below. Seating for this '.$learntype_arr[2].' is limited. Get started today!

'; $output_all .= '
'; } $url_state_folder = str_replace(" ", "-", strtolower($row['state'])); $url_state_anchor = $row['state']." (".$row['abbr'].")"; $url_city_folder = str_replace(" ", "-", strtolower($row['city'])); $url_city_anchor = $row['city'].", ".$row['abbr']; $url_title_this = $url_title.' in '.$row['city'].', '.$row['state']; $url_str = ''.$url_city_anchor.''; $output_all .= $url_str; $output_all .= '
'; $this_count++; } //without microdata //$url_this_topnav_product = ''.$brand_kw1.' Training'; //$url_this_topnav_title = ''.$url_title.''; //$url_this_topnav_state = ''.$url_state_anchor.''; //$url_this_topnav = $url_this_topnav_product." » ".$url_this_topnav_title." » ".$url_state_anchor." (Choose your city)"; $url_div_breadcrumb_open = ''; $url_div_breadcrumb_close = ''; $url_div_breadcrumb_itemprop_open = ''; $url_div_breadcrumb_itemprop_close = ''; $url_this_topnav_product = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_title = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_state = $url_div_breadcrumb_open.' '.$url_div_breadcrumb_close; //$url_this_topnav_city = $url_div_breadcrumb_open.''.$url_div_breadcrumb_close; $url_this_topnav = ''.$url_this_topnav_product.' '.$url_this_topnav_title.' '.$url_this_topnav_state.' (Choose your city)'; //$output_all .= ''; //$output_all .= '

'.$url_title.' in '.$geo_state.'

//

aa'.$geo_state.' '.$url_title.'. To find a '.$brand_kw1.' '.$learntype_arr[2].' in '.$geo_state.' please select a city in '.$geo_state.' ('.$row['abbr'].') below. Seating for this '.$learntype_arr[2].' is limited. Get started today!

//



'; //$output_all .= ''; $output_all .= '


'; }else{ //state not found in the database - give them a 404 header('HTTP/1.0 404 Not Found'); include("404.php"); exit(); } } if($state_found==0){ $stateslist_type = 1; //list type 1 includes cities //list type 2 links to state subpages $sql = ''; $sql = 'SELECT distinct state, abbr FROM geolist_major_state_abbr_city order by state asc'; $result = $db->query($sql); $this_count = $result->size(); //echo $this_count; //$row = $result->fetch(); //extract($row); if(isset($url_subfolder)){ if($stateslist_type==1){ global $db2; //get total count of cities since we list everything here and we want the columns to line up equally $sql2 = ''; $sql2 = 'SELECT state, abbr, city FROM geolist_major_state_abbr_city'; $result2 = $db2->query($sql2); $this_count_cities = $result2->size(); $total_columns = 2; //total count of states $column_max = ($this_count_cities+20)/$total_columns; //$output_all = ''; //$output_all .= ''; //$output_all .= ''; $output_all = '
'; $output_all .= '

'.$url_title.'

'.$url_title.'. For a schedule of '.$brand_kw1.' '.$learntype_arr[2].' dates near you, please choose your city or state below. A '.$brand_kw2.' '.$learntype_arr[1].' will help you know how to use '.$brand_kw1.'. Locate and register for a '.$brand_kw1.' '.$learntype_arr[2].' today.

'; $this_count_states = 0; $this_count_cities = 0; while($row = $result->fetch()) { //if($this_count_states==0){ // $output_all .= ''; //$output_all .= ''; $this_count_cities = 0; } //if($this_count_states>$column_max){ //$output_all .= ''; // //$output_all .= ''; //$this_count = 0; //} } //without microdata //$url_this_topnav_product = ''.$brand_kw1.' Training'; //$url_this_topnav_title = ''.$url_title.''; //$url_this_topnav_state = ''.$url_state_anchor.''; //$url_this_topnav = $url_this_topnav_product." » ".$url_title." (Choose your state)"; $url_div_breadcrumb_open = ''; $url_div_breadcrumb_close = ''; $url_div_breadcrumb_itemprop_open = ''; $url_div_breadcrumb_itemprop_close = ''; $url_this_topnav_product = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; $url_this_topnav_title = $url_div_breadcrumb_open.' '.$url_div_breadcrumb_close; //$url_this_topnav_state = $url_div_breadcrumb_open.' >'.$url_div_breadcrumb_close; //$url_this_topnav_city = $url_div_breadcrumb_open.''.$url_div_breadcrumb_close; $url_this_topnav = ''.$url_this_topnav_product.' '.$url_this_topnav_title.' (Choose your state or city)'; //$output_all .= ''; //$output_all .= '

'.$url_title.'

//

'.$url_title.'. For a schedule of '.$brand_kw1.' '.$learntype_arr[2].' dates near you, please choose your city or state below. A '.$brand_kw2.' '.$learntype_arr[1].' will help you know how to use '.$brand_kw1.'. Locate and register for a '.$brand_kw1.' '.$learntype_arr[2].' today.

'; //} if($this_count_cities==0){ $output_all .= '
'; } $url_state_folder = str_replace(" ", "-", strtolower($row['state'])); $url_state_anchor = $row['state']." (".$row['abbr'].")"; $url_title_this = $url_title.' in '. $row['state']; $url_str = '

'.$url_state_anchor.' '.$url_title.'

'; $output_all .= $url_str; //grab the cities $geo_state = mysql_real_escape_string($row['state']); $sql2 = ''; $sql2 = 'SELECT state, abbr, city FROM geolist_major_state_abbr_city where state = "'.$geo_state.'" order by city asc'; $result2 = $db2->query($sql2); $this_count_states_cities = $result2->size(); if($this_count_states_cities>0){ //$output_all .= '
'; //$output_all .= ''; $output_all .= '
'; $this_count2 = 0; while($row2 = $result2->fetch()) { if($this_count_states_cities==0){ //$output_all .= '

'.$url_title.' in '.$geo_state.'

'; $output_all .= '

'; } $url_state_folder2 = str_replace(" ", "-", strtolower($row2['state'])); $url_state_anchor2 = $row2['state']." (".$row2['abbr'].")"; $url_city_folder2 = str_replace(" ", "-", strtolower($row2['city'])); $url_city_anchor2 = $row2['city']; $url_title_this2 = $url_title.' in '.$row2['city'].', '.$row2['state']; $url_str2 = '

'.$url_city_anchor2.''; $output_all .= $url_str2; //$output_all .= '
'; $output_all .= '

'; $this_count_states_cities++; $this_count_cities++; } //$url_this_topnav_product = ''.$brand_kw1.' Training'; //$url_this_topnav_title = ''.$url_title.''; //$url_this_topnav_state = ''.$url_state_anchor.''; //$url_this_topnav = $url_this_topnav_product." » ".$url_this_topnav_title." » ".$url_state_anchor." (Choose your city)"; //$output_all .= '
'; $output_all .= '
'; } $output_all .= '
'; $this_count++; if($this_count_cities>$column_max){ $output_all .= ''; //$output_all .= '



'; //$output_all .= '

'; //clear out city data for header $geo_city=''; $geo_state=''; }else{ //if($stateslist_type==1){ $total_columns = 3; $column_max = $this_count/$total_columns; $output_all = ''; $output_all .= ''; $output_all .= ''; $this_count = 0; while($row = $result->fetch()) { if($this_count==0){ $output_all .= ''; //$output_all .= ''; $this_count = 0; } } $url_this_topnav_product = ''.$brand_kw1.' Training'; $url_this_topnav_title = ''.$url_title.''; $url_this_topnav_state = ''.$url_state_anchor.''; $url_this_topnav = $url_this_topnav_product." » ".$url_title." (Choose your state)"; $output_all .= ''; $output_all .= '

'.$url_title.'

'; } $url_state_folder = str_replace(" ", "-", strtolower($row['state'])); $url_state_anchor = $row['state']." (".$row['abbr'].")"; $url_title_this = $url_title.' in '. $row['state']; $url_str = ''.$url_state_anchor.''; $output_all .= $url_str; $output_all .= '
'; $this_count++; if($this_count>$column_max){ $output_all .= '



'; } //if($stateslist_type==1) }else{//if(isset($url_subfolder)){ //subfolder not found in the database - give them a 404 header('HTTP/1.0 404 Not Found'); include("404.php"); exit(); }//if(isset($url_subfolder)){ } include("inc_site_header.php"); //echo "

"; //echo '
'.$url_this_topnav.'
'; echo '
'.$url_this_topnav.'
'; echo $output_all; //echo "
"; include("inc_site_footer.php"); } } ?>