<?
error_reporting(E_ALL);
ini_set('display_errors', '1');

//// Include MySQL class
//require_once('inc/mysql.class.php');
//// Include database connection
//require_once('inc/global.inc.php');
//// Include functions
//require_once('inc/functions.inc.php');
//// Include customer details functions
//require_once('inc/inc_customerdetails.php');

//// Include routing functions
//require_once('checkout_routing.php');

// Start the session
session_start();



//$course_category = "quickbooks_seminars";

$course_category = $_GET["course_category"];
$geo_state = mb_convert_case($_GET["geo_state"],MB_CASE_TITLE);
$geo_city = mb_convert_case($_GET["geo_city"],MB_CASE_TITLE);

$geo_city = str_replace("-", " ", $geo_city);
$geo_state = str_replace("-", " ", $geo_state);

$course_category = str_replace("/", "", $course_category);

//$current_page = trim(curPageName());


ob_start();


define('SITE_PROTOCOL', curProtocol() );
define('SITE_DOMAIN', SITE_PROTOCOL.$_SERVER['HTTP_HOST']);

$local_folder = '/local/north-america/united-states/';

if($geo_state!=''){
	$local_folder .= $_GET["geo_state"].'/';

	if($geo_city!=''){
		$local_folder .= $_GET["geo_city"].'/';
	}
}

echo SITE_DOMAIN.$local_folder;

header("HTTP/1.1 301 Moved Permanently");
header("Location: ".SITE_DOMAIN.$local_folder);
die();








function curProtocol()
{  // senses protocol - $_SERVER["HTTP_USESSL"] should catch when behind load balancing
	if(!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off'){
	 $protocol = "https://";
	}elseif($_SERVER['SERVER_PORT'] == 443 || isset($_SERVER["HTTP_USESSL"])){
	 $protocol = "https://";
	}else{
	 $protocol = "//";
	}
  return $protocol;
}//function siteProtocol()













geo_pages($course_category, $geo_state, $geo_city);







function geo_pages($course_category, $geo_state, $geo_city){

	global $db;

	$state_found=0;


	if($course_category==""){
		echo "no category defined";
		die();
	}

							//$learntype_arr = array("seminars", "seminar");
							//$learntype_arr = array("classes", "class");
							//$learntype_arr = array("courses", "course");


	switch ($course_category){
		case "quickbooks-seminars":
				$url_subfolder = "quickbooks-seminars";
				$url_title = "QuickBooks Seminars";

				$brand_kw1 = "QuickBooks";
				$brand_kw2 = "QuickBooks";

				$url_location = "//www.bookstraining.com/quickbooks-training.php";

				$brand_kw1_videoimage="quickbooks-training-demo-video.jpg";

				$learntype_arr = array("seminars", "seminar", "training seminar");
			break;
		case "quickbooks-classes":
				$url_subfolder = "quickbooks-classes";
				$url_title = "QuickBooks Classes";

				$brand_kw1 = "QuickBooks";
				$brand_kw2 = "QuickBooks";

				$url_location = "//www.bookstraining.com/quickbooks-training.php";

				$brand_kw1_videoimage="quickbooks-training-demo-video.jpg";

				$learntype_arr = array("classes", "class", "training class");
			break;
		case "quickbooks-courses":
				$url_subfolder = "quickbooks-courses";
				$url_title = "QuickBooks Courses";

				$brand_kw1 = "QuickBooks";
				$brand_kw2 = "QuickBooks";

				$url_location = "//www.bookstraining.com/quickbooks-training.php";

				$brand_kw1_videoimage="quickbooks-training-demo-video.jpg";

				$learntype_arr = array("courses", "course", "training course");
			break;



		case "accounting-seminars":
				$url_subfolder = "accounting-seminars";
				$url_title = "Accounting Seminars";

				$brand_kw1 = "Accounting";
				$brand_kw2 = "Accounting";

				$url_location = "//www.bookstraining.com/accounting-courses.php";

				$brand_kw1_videoimage="accounting-training-demo-video.jpg";

				$learntype_arr = array("seminars", "seminar", "training seminar");
			break;
		case "accounting-classes":
				$url_subfolder = "accounting-classes";
				$url_title = "Accounting Classes";

				$brand_kw1 = "Accounting";
				$brand_kw2 = "Accounting";

				$url_location = "//www.bookstraining.com/accounting-courses.php";

				$brand_kw1_videoimage="accounting-training-demo-video.jpg";

				$learntype_arr = array("classes", "class", "training class");
			break;
		case "accounting-courses":
				$url_subfolder = "accounting-courses";
				$url_title = "Accounting Courses";

				$brand_kw1 = "Accounting";
				$brand_kw2 = "Accounting";

				$url_location = "//www.bookstraining.com/accounting-courses.php";

				$brand_kw1_videoimage="accounting-training-demo-video.jpg";

				$learntype_arr = array("courses", "course", "training course");
			break;



		case "bookkeeping-seminars":
			$url_subfolder = "bookkeeping-seminars";
			$url_title = "Bookkeeping Seminars";

			$brand_kw1 = "Bookkeeping";
			$brand_kw2 = "Bookkeeping";

			$url_location = "//www.bookstraining.com/accounting-courses.php";

			$brand_kw1_videoimage="accounting-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;

		case "bookkeeping-classes":
			$url_subfolder = "bookkeeping-classes";
			$url_title = "Bookkeeping Classes";

			$brand_kw1 = "Bookkeeping";
			$brand_kw2 = "Bookkeeping";

			$url_location = "//www.bookstraining.com/accounting-courses.php";

			$brand_kw1_videoimage="accounting-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;

		case "bookkeeping-courses":
			$url_subfolder = "bookkeeping-courses";
			$url_title = "Bookkeeping Courses";

			$brand_kw1 = "Bookkeeping";
			$brand_kw2 = "Bookkeeping";

			$url_location = "//www.bookstraining.com/accounting-courses.php";

			$brand_kw1_videoimage="accounting-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;



		case "microsoft-excel-seminars":
			$url_subfolder = "microsoft-excel-seminars";
			$url_title = "Microsoft Excel Seminars";

			$brand_kw1 = "Microsoft Excel";
			$brand_kw2 = "MS Excel";

			$url_location = "//www.bookstraining.com/microsoft-excel-training.php";

			$brand_kw1_videoimage="excel-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;
		case "microsoft-excel-classes":
			$url_subfolder = "microsoft-excel-classes";
			$url_title = "Microsoft Excel Classes";

			$brand_kw1 = "Microsoft Excel";
			$brand_kw2 = "MS Excel";

			$url_location = "//www.bookstraining.com/microsoft-excel-training.php";

			$brand_kw1_videoimage="excel-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;
		case "microsoft-excel-courses":
			$url_subfolder = "microsoft-excel-courses";
			$url_title = "Microsoft Excel Courses";

			$brand_kw1 = "Microsoft Excel";
			$brand_kw2 = "MS Excel";

			$url_location = "//www.bookstraining.com/microsoft-excel-training.php";

			$brand_kw1_videoimage="excel-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;



		case "microsoft-access-seminars":
			$url_subfolder = "microsoft-access-seminars";
			$url_title = "Microsoft Access Seminars";

			$brand_kw1 = "Microsoft Access";
			$brand_kw2 = "MS Access";

			$url_location = "//www.bookstraining.com/microsoft-access-training.php";

			$brand_kw1_videoimage="access-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;
		case "microsoft-access-classes":
			$url_subfolder = "microsoft-access-classes";
			$url_title = "Microsoft Access Classes";

			$brand_kw1 = "Microsoft Access";
			$brand_kw2 = "MS Access";

			$url_location = "//www.bookstraining.com/microsoft-access-training.php";

			$brand_kw1_videoimage="access-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;
		case "microsoft-access-courses":
			$url_subfolder = "microsoft-access-courses";
			$url_title = "Microsoft Access Courses";

			$brand_kw1 = "Microsoft Access";
			$brand_kw2 = "MS Access";

			$url_location = "//www.bookstraining.com/microsoft-access-training.php";

			$brand_kw1_videoimage="access-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;



		case "microsoft-powerpoint-seminars":
			$url_subfolder = "microsoft-powerpoint-seminars";
			$url_title = "Microsoft PowerPoint Seminars";

			$brand_kw1 = "Microsoft PowerPoint";
			$brand_kw2 = "MS PowerPoint";

			$url_location = "//www.bookstraining.com/microsoft-powerpoint-training.php";

			$brand_kw1_videoimage="microsoft-powerpoint-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;
		case "microsoft-powerpoint-classes":
			$url_subfolder = "microsoft-powerpoint-classes";
			$url_title = "Microsoft PowerPoint Classes";

			$brand_kw1 = "Microsoft PowerPoint";
			$brand_kw2 = "MS PowerPoint";

			$url_location = "//www.bookstraining.com/microsoft-powerpoint-training.php";

			$brand_kw1_videoimage="microsoft-powerpoint-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;
		case "microsoft-powerpoint-courses":
			$url_subfolder = "microsoft-powerpoint-courses";
			$url_title = "Microsoft PowerPoint Courses";

			$brand_kw1 = "Microsoft PowerPoint";
			$brand_kw2 = "MS PowerPoint";

			$url_location = "//www.bookstraining.com/microsoft-powerpoint-training.php";

			$brand_kw1_videoimage="microsoft-powerpoint-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;



		case "microsoft-project-seminars":
			$url_subfolder = "microsoft-project-seminars";
			$url_title = "Microsoft Project Seminars";

			$brand_kw1 = "Microsoft Project";
			$brand_kw2 = "MS Project";

			$url_location = "//www.bookstraining.com/microsoft-project-training.php";

			$brand_kw1_videoimage="microsoft-project-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;
		case "microsoft-project-classes":
			$url_subfolder = "microsoft-project-classes";
			$url_title = "Microsoft Project Classes";

			$brand_kw1 = "Microsoft Project";
			$brand_kw2 = "MS Project";

			$url_location = "//www.bookstraining.com/microsoft-project-training.php";

			$brand_kw1_videoimage="microsoft-project-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;
		case "microsoft-project-courses":
			$url_subfolder = "microsoft-project-courses";
			$url_title = "Microsoft Project Courses";

			$brand_kw1 = "Microsoft Project";
			$brand_kw2 = "MS Project";

			$url_location = "//www.bookstraining.com/microsoft-project-training.php";

			$brand_kw1_videoimage="microsoft-project-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;



		case "microsoft-word-seminars":
			$url_subfolder = "microsoft-word-seminars";
			$url_title = "Microsoft Word Seminars";

			$brand_kw1 = "Microsoft Word";
			$brand_kw2 = "MS Word";

			$url_location = "//www.bookstraining.com/microsoft-word-training.php";

			$brand_kw1_videoimage="microsoft-word-training-demo-video.jpg";

			$learntype_arr = array("seminars", "seminar", "training seminar");

			break;
		case "microsoft-word-classes":
			$url_subfolder = "microsoft-word-classes";
			$url_title = "Microsoft Word Classes";

			$brand_kw1 = "Microsoft Word";
			$brand_kw2 = "MS Word";

			$url_location = "//www.bookstraining.com/microsoft-word-training.php";

			$brand_kw1_videoimage="microsoft-word-training-demo-video.jpg";

			$learntype_arr = array("classes", "class", "training class");

			break;
		case "microsoft-word-courses":
			$url_subfolder = "microsoft-word-courses";
			$url_title = "Microsoft Word Courses";

			$brand_kw1 = "Microsoft Word";
			$brand_kw2 = "MS Word";

			$url_location = "//www.bookstraining.com/microsoft-word-training.php";

			$brand_kw1_videoimage="microsoft-word-training-demo-video.jpg";

			$learntype_arr = array("courses", "course", "training course");

			break;

		default:


		break;

	}




	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)){




	$this_count = 0;

	if($geo_city!=''){

		//confirm the city exists in the database
		$sql = '';
		$sql = 'SELECT state, abbr, city FROM geolist_major_state_abbr_city
			where state = "'.$geo_state.'" AND city = "'.$geo_city.'" order by city asc';

		$result = $db->query($sql);

		$this_count = $result->size();

		if($this_count>0){

			include("inc_site_header.php");
				//echo '<div style="text-align:center;"><br/>';
																//echo "<center><BR>";

					$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 = '<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'">'.$brand_kw1.' Training</a>';
													//$url_this_topnav_title = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'">'.$url_title.'</a>';
													//$url_this_topnav_state = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'">'.$url_state_anchor.'</a>';
													//echo "<div align=left>".$url_this_topnav_product." &raquo; ".$url_this_topnav_title." &raquo; ".$url_this_topnav_state." &raquo; ".$geo_city."</div>";


					$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.'<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'" itemprop="url">'.$brand_kw1.' Training</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
					$url_this_topnav_title = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'" itemprop="url">'.$url_title.'</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
					$url_this_topnav_state = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'" itemprop="url">'.$url_state_anchor.'</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
					$url_this_topnav_city = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/'.$url_city_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_city_anchor.', '.$url_state_anchor.'" itemprop="url">'.$url_city_anchor.'</a>'.$url_div_breadcrumb_close;


													//echo '<div align="left" itemprop="breadcrumb">'.$url_this_topnav_product.'&nbsp;'.$url_this_topnav_title.'&nbsp;'.$url_this_topnav_state.'&nbsp;'.$url_this_topnav_city.'</div>';
					echo '<div style="text-align:left;" itemprop="breadcrumb">'.$url_this_topnav_product.'&nbsp;'.$url_this_topnav_title.'&nbsp;'.$url_this_topnav_state.'&nbsp;'.$url_this_topnav_city.'</div>';

					require_once('geo_lists_page.php');

													//echo "</center>";
				//echo '</div>';
			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 = '<table width="85%"><tr>';

				$output_all = '<div style="width:85%;">';

				$this_count = 0;
				while($row = $result->fetch()) {

					if($this_count==0){

																	//$output_all .= '<td valign=top><h1 style="margin-bottom:0;">'.$url_title.' in '.$geo_state.'</h1>
																	//<p style="margin-top:0;"> 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!</p>
																	//</td></tr><tr>';

						$output_all .= '<div style="vertical-align:top;">';
						$output_all .= '<h1 style="margin-bottom:5px;">'.$url_title.' in '.$geo_state.'</h1>';
						$output_all .= '<p style="margin-top:0;">'.$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!</p>';
						$output_all .= '</div>';

					}

					$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 = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/'.$url_city_folder.'/" title="'.$url_title_this.'"  class="cities_t2">'.$url_city_anchor.'</a>';

					$output_all .= $url_str;

					$output_all .= '<br/>';

				$this_count++;
				}


																		//without microdata
																		//$url_this_topnav_product = '<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'">'.$brand_kw1.' Training</a>';
																		//$url_this_topnav_title = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'">'.$url_title.'</a>';
																		//$url_this_topnav_state = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'">'.$url_state_anchor.'</a>';

																		//$url_this_topnav = $url_this_topnav_product." &raquo; ".$url_this_topnav_title." &raquo; ".$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.'<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'" itemprop="url">'.$brand_kw1.' Training</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
				$url_this_topnav_title = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'" itemprop="url">'.$url_title.'</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
				$url_this_topnav_state = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'" itemprop="url">'.$url_state_anchor.'</a>&nbsp;'.$url_div_breadcrumb_close;
																			//$url_this_topnav_city = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/'.$url_city_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_city_anchor.', '.$url_state_anchor.'" itemprop="url">'.$url_city_anchor.'</a>'.$url_div_breadcrumb_close;

				$url_this_topnav = ''.$url_this_topnav_product.'&nbsp;'.$url_this_topnav_title.'&nbsp;'.$url_this_topnav_state.'&nbsp;(Choose your city)';


																			//$output_all .= '</td></tr>';
																			//$output_all .= '</table><BR><BR><BR>';

				//$output_all .= '</div>';
				$output_all .= '<br/><br/><br/>';

			}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 = '<table width="85%">';
												//$output_all .= '<tr>';
												//$output_all .= '<td valign=top colspan='.$total_columns.'><h1 style="margin-bottom:5px;">'.$url_title.'</h1>
												//<p style="margin-top:0;">'.$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.</p></td></tr><tr>';


					$output_all = '<div style="width:85%">';
					$output_all .= '<h1 style="margin-bottom:5px;">'.$url_title.'</h1>
					<p style="margin-top:0;">'.$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.</p></div>';



					$this_count_states = 0;
					$this_count_cities = 0;

					while($row = $result->fetch()) {

												//if($this_count_states==0){
												//	$output_all .= '<td valign=top>';
												//}

						if($this_count_cities==0){
							$output_all .= '<div style="vertical-align:top" class="responsiveblock">';
						}

						$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 = '<p><a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$url_title_this.'" class="states_t1">'.$url_state_anchor.' '.$url_title.'</a></p>';

						$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 .= '<BR><table width="85%"><tr>';
																			//$output_all .= '<td valign=top><h1>'.$url_title.' in '.$geo_state.'</h1></td></tr><tr>';
								$output_all .= '<div style="border:0px solid #7a7a7a;" class="responsiveblock">';

								$this_count2 = 0;
								while($row2 = $result2->fetch()) {

									if($this_count_states_cities==0){
																			//$output_all .= '<td valign=top>';
										$output_all .= '<p>';
									}

									$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 = '<p><a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder2.'/'.$url_city_folder2.'/" title="'.$url_title_this2.'" class="cities_t1">'.$url_city_anchor2.'</a>';

									$output_all .= $url_str2;

									//$output_all .= '<br/>';

									$output_all .= '</p>';

								$this_count_states_cities++;
								$this_count_cities++;
								}

																					//$url_this_topnav_product = '<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'">'.$brand_kw1.' Training</a>';
																					//$url_this_topnav_title = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'">'.$url_title.'</a>';
																					//$url_this_topnav_state = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'">'.$url_state_anchor.'</a>';

																					//$url_this_topnav = $url_this_topnav_product." &raquo; ".$url_this_topnav_title." &raquo; ".$url_state_anchor." (Choose your city)";

								//$output_all .= '</td></tr></table>';
								$output_all .= '</div>';

							}


						$output_all .= '<br/>';

					$this_count++;

						if($this_count_cities>$column_max){


						$output_all .= '</div>';
																					//$output_all .= '</td>';
																					//$output_all .= '</tr>';
						$this_count_cities = 0;
						}

																					//if($this_count_states>$column_max){
																					//$output_all .= '</td>';
																					//	//$output_all .= '</tr>';
																					//$this_count = 0;
																					//}
					}


																					//without microdata
																					//$url_this_topnav_product = '<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'">'.$brand_kw1.' Training</a>';
																					//$url_this_topnav_title = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'">'.$url_title.'</a>';
																					//$url_this_topnav_state = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'">'.$url_state_anchor.'</a>';
																					//$url_this_topnav = $url_this_topnav_product." &raquo; ".$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.'<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'" itemprop="url">'.$brand_kw1.' Training</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
				$url_this_topnav_title = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'" itemprop="url">'.$url_title.'</a>&nbsp;'.$url_div_breadcrumb_close;
																						//$url_this_topnav_state = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'" itemprop="url">'.$url_state_anchor.'</a>&nbsp;&gt;'.$url_div_breadcrumb_close;
																						//$url_this_topnav_city = $url_div_breadcrumb_open.'<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/'.$url_city_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_city_anchor.', '.$url_state_anchor.'" itemprop="url">'.$url_city_anchor.'</a>'.$url_div_breadcrumb_close;

				$url_this_topnav = ''.$url_this_topnav_product.'&nbsp;'.$url_this_topnav_title.'&nbsp;(Choose your state or city)';



																			//$output_all .= '</td></tr>';
																			//$output_all .= '</table><BR><BR><BR>';

					//$output_all .= '</div><br/><br/>';


					//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 = '<table width="85%">';
					$output_all .= '<tr>';

					$output_all .= '<td valign=top colspan='.$total_columns.'><h1 style="margin-bottom:5px;">'.$url_title.'</h1></td></tr><tr>';

					$this_count = 0;
					while($row = $result->fetch()) {

						if($this_count==0){

							$output_all .= '<td valign=top>';
						}

						$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 = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$url_title_this.'">'.$url_state_anchor.'</a>';

						$output_all .= $url_str;

						$output_all .= '<br>';

					$this_count++;

						if($this_count>$column_max){

						$output_all .= '</td>';
						//$output_all .= '</tr>';
						$this_count = 0;
						}
					}

					$url_this_topnav_product = '<a href="'.$url_location.'" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).'">'.$brand_kw1.' Training</a>';
					$url_this_topnav_title = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/" title="'.$url_title.'">'.$url_title.'</a>';
					$url_this_topnav_state = '<a href="//'.$_SERVER['HTTP_HOST'].'/live-'.$url_subfolder.'/'.$url_state_folder.'/" title="'.$brand_kw1.' '.mb_convert_case($learntype_arr[2],MB_CASE_TITLE).' in '.$url_state_anchor.'">'.$url_state_anchor.'</a>';
					$url_this_topnav = $url_this_topnav_product." &raquo; ".$url_title." (Choose your state)";



					$output_all .= '</td></tr>';
					$output_all .= '</table><BR><BR><BR>';


				} //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 "<center><BR>";

											//echo '<div itemprop="breadcrumb" align="left">'.$url_this_topnav.'</div>';
		echo '<div itemprop="breadcrumb" style="text-align:left;margin-bottom:5px;">'.$url_this_topnav.'</div>';

		echo $output_all;

//echo "</center>";
include("inc_site_footer.php");

	}

}


?>