include("includes/include-top.php"); $dim_url = explode('/', $_SERVER['REQUEST_URI']); $movement_url =$dim_url[sizeof($dim_url)-1]; $isPresentURL = com_db_GetValue("select move_id from ".TABLE_MOVEMENT_MASTER." where movement_url='".$movement_url."'"); if( $isPresentURL=='' ){ $move_id = $_REQUEST['movement_id']; if($move_id !=''){ $movement_url = com_db_GetValue("select movement_url from ".TABLE_MOVEMENT_MASTER." where move_id='".$move_id."'"); } $url_arr = explode('-at-',$movement_url); if(sizeof($url_arr)<=1 ){ $url_arr = explode('-from-',$movement_url); } $url_arr_sub = explode('-',$url_arr[0]); $now_url = $url_arr_sub[0].'-'.$url_arr_sub[1].'%'.preg_replace(array('/[^a-zA-Z0-9 -]/', '/[ -]+/', '/^-|-$/'), array('', '-', ''), $url_arr[1]); $movement_url = com_db_GetValue("select movement_url from ".TABLE_MOVEMENT_MASTER." where movement_url like '".$now_url."'"); if($movement_url !=''){ com_redirect($movement_url); }elseif( $movement_url =='' ){ $url ='not-found.php'; com_redirect($url); } } $movementQuery = 'select mm.move_id,mm.personal_id,mm.company_id,mm.title,mm.what_happened,mm.headline,mm.movement_type,s.source,mm.announce_date,cm.company_website,cm.company_name,cm.about_company,cm.industry_id,pm.first_name,pm.last_name,pm.email,pm.phone,pm.about_person from ' .TABLE_MOVEMENT_MASTER . ' as mm, ' .TABLE_PERSONAL_MASTER. ' as pm, ' .TABLE_COMPANY_MASTER . ' as cm, ' .TABLE_INDUSTRY . ' as i, ' .TABLE_SOURCE . ' as s where mm.company_id=cm.company_id and mm.personal_id=pm.personal_id and mm.source_id=s.id and mm.movement_url = "'.$movement_url.'"'; $movementResult = com_db_query($movementQuery); $mmRow = com_db_fetch_array($movementResult); $a_date = @explode('-',$mmRow['announce_date']); if(sizeof($a_date)>1){ $announce_date = date("F d, Y", mktime(0,0,0,$a_date[1],$a_date[2],$a_date[0])); } $comp_domain_name=''; if($mmRow['company_website'] !=''){ $comp = array("http://wwww.", "www.","https://www.","http://","https://"); $comp_domain_name = str_replace($comp,'',$mmRow['company_website']); $comp_domain_name =' @'. $comp_domain_name; } $notCurrent = $mmRow['not_current']; $PageTitle = $PageTitle.$comp_domain_name.' CFOsOnTheMove'; $movement_type = $mmRow['movement_type']; $PageKeywords=com_db_output($mmRow['first_name']).' '.com_db_output($mmRow['last_name']).', '.com_db_output($mmRow['title']).', '.com_db_output($mmRow['company_name']).', email, '.$comp_domain_name.', CFOsOnTheMove, '.$mt_type; $PageDescription='Looking for '.com_db_output($mmRow['first_name']).' '.com_db_output($mmRow['last_name']).', '.com_db_output($mmRow['title']).' at '.com_db_output($mmRow['company_name']).'? Contact '.com_db_output($mmRow['first_name']).' today at updated'.$comp_domain_name.' email, phone and address here at '.com_db_output($mmRow['first_name'])."'s profile at CFOsOnTheMove"; include_once('includes/header_new.php'); ?>
Date of management change: