include("includes/include-top.php"); $dim_url = explode('/', $_SERVER['REQUEST_URI']); $company_url =$dim_url[sizeof($dim_url)-1]; $company_arr = explode("_",$company_url); $comsize = sizeof($company_arr); $company_id = $company_arr[$comsize-1]; if(trim($company_id)==''){ $url ='not-found.php'; com_redirect($url); }elseif(trim($company_id)!=''){ $isCompanyID = com_db_GetValue("select company_id from ".TABLE_COMPANY_MASTER." where company_id='".$company_id."'"); if($isCompanyID==''){ $url ='not-found.php'; com_redirect($url); } } $companyQuery = 'select cm.*,rs.name as revenue,es.name as employee,s.short_name,ind.title,s.state_name,c.countries_name,c.countries_iso_code_3 from ' .TABLE_COMPANY_MASTER. ' as cm, ' .TABLE_REVENUE_SIZE. ' as rs, ' .TABLE_EMPLOYEE_SIZE. ' as es, ' .TABLE_INDUSTRY. ' as ind, ' .TABLE_STATE. ' as s, ' .TABLE_COUNTRIES. ' as c' .' where cm.company_revenue=rs.id and cm.company_employee=es.id and cm.state = s.state_id and cm.country=c.countries_id and cm.industry_id=ind.industry_id and cm.company_id = "'.$company_id.'"'; $companyResult = com_db_query($companyQuery); $companyRow = com_db_fetch_array($companyResult); $company_address = com_db_output($companyRow['address'].' '.$companyRow['address2'].', '.$companyRow['short_name'].', '.$companyRow['countries_iso_code_3'].', '.$companyRow['zip_code']); $comp_domain_name=''; if($companyRow['company_website'] !=''){ $comp = array("http://wwww.", "www.","https://www.","http://","https://"); $comp_domain_name = str_replace($comp,'',$companyRow['company_website']); $comp_domain_name =' @'. $comp_domain_name; } $PageTitle = com_db_output($companyRow['company_name']).', '.com_db_output($companyRow['city']).', '.com_db_output($companyRow['short_name']); $PageKeywords=com_db_output($companyRow['company_name']).', Email, '.$comp_domain_name.', executives, ceo, cfo, vp, address, addresses, e-mail, management'; $PageDescription="CFOsOnTheMove's profile for ".com_db_output($companyRow['company_name']).' with executive profiles for CEO, CIO, CMO, CFO info including email address, '.$comp_domain_name.', linkedin, biography'; ?>