getTemplate(); $sugarDB = JFactory::getDBO(); $option = array(); $option['driver'] = 'mysqli'; $option['host'] = DBHOST; $option['user'] = DBUSR; $option['password'] = DBPSWD; $option['database'] = DBNAME; $option['prefix'] = ''; $sugarDB = JDatabase::getInstance( $option ); $iId = JRequest::getVar('id',0); $database = &JFactory::getDBO(); $catid = $_REQUEST['id']; $sql = "SELECT title FROM #__categories WHERE id = ".$catid; $database->setQuery( $sql ); $content = $database->loadObject(); $category=$content->title; $prepared_category = strtolower(str_replace(" ","",$category)); $sql = "SELECT * FROM vip_inforecovery_addresses vca WHERE vca.`address_city` = '".$category."' AND vca.`deleted` = '0' AND vca.`for_frontend` = '1' LIMIT 1"; $sugarDB->setQuery($sql); $facility = $sugarDB->loadObject(); $facility->name = str_replace( 'Data Retrieval', 'Info Recovery', $facility->name ); $facility->email = str_replace( 'dataretrieval', 'inforecovery', $facility->email ); /* // var_dump($facility); echo $facility->name.'
'; echo $facility->address_street.'
'; echo $facility->address_city.'
'; echo $facility->address_state.'
'; echo $facility->address_postalcode.'
'; echo $facility->phone.'
'; echo $facility->office_hours_mon_fri.'
'; */ ?>

Data Recovery Services
in location_city; ?>

InfoRecovery LLC
address_street; ?>
address_city.', '.$facility->address_state.' '.$facility->address_postalcode; ?>
phone; ?>
Office Hours:
Mon - Fri: office_hours_mon_fri; ?>
After Hours:
Call for 24/7 Emergency Service
Available 24 hours a day
X