”) {
$myselection = $mysselection;
}
if ($mycselection <> ”) {
$myselection = $mycselection;
}
if ($mydselection <> ”) {
$myselection = $mydselection;
}

?>

Rep Finder

At HIX Industrial Ovens, we consider our history, quality and service to be the foundation of our company. To ensure a high level of quality and service, we have a network of reps who are knowledgeable, ethical, and professional. In the event a rep does not cover your territory or industry, we are here to help you with in-house service and personnel.

Select Your Area

United States

Canada

International

”) {
global $wpdb;

if ($myselection == ‘kansas’ || $myselection == ‘mexico’ || $myselection == ‘virginia’) {
if ($myselection == ‘kansas’) {
$myregionids = $wpdb->get_results(“SELECT * FROM ovenRep121015 WHERE replineid = ’23′”);
}

if ($myselection == ‘virginia’) {
$myregionids = $wpdb->get_results(“SELECT * FROM ovenRep121015 WHERE replineid = ‘7’ OR replineid = ‘8’”);
}

if ($myselection == ‘mexico’) {
$myregionids = $wpdb->get_results(“SELECT * FROM ovenRep121015 WHERE replineid = ’45′”);
}

} else {
$myregionids = $wpdb->get_results(“SELECT * FROM ovenRep121015 WHERE state like ‘%”.$myselection.”%'”);
}

foreach ( $myregionids as $myregionid )
{
$myregionidused = $myregionid->regionid;
$myterritory = $myregionid->territory;
$myregiontext = $myregionid->region;

$mystate = $myregionid->state;
$myrep = $myregionid->rep;
$myphone = $myregionid->phone;
$myphone2 = $myregionid->phone2;
$myfax = $myregionid->fax;
$mywebsite = $myregionid->website;
$myemail = $myregionid->email;
$mycompany = $myregionid->company;
$myIndServ = $myregionid->primIndustry;
$myGeoServ = $myregionid->primaryGeo;
?>