Class Number: TS42 11-29-18
Class Title: Rooftop Startup and Controls
Class Date: November 29, 2018
Class Location: 10380 Julian Dr., Cincinnati, OH, 45215
URL:
Class Description:
* Last Name:
* First Name:
* Company Name:
Email Address:
Confirm Email Address:
Dealer Status:   
* Company Address 1:
Company Address 2:
* Company City:
* Company State:
* Company Zip:
* Company Phone:
Company Fax:
Account Status: I, or the company I work for, DO NOT currently have an open account with Virginia Air Distributers.
I, or the company I work for, DO currently have an open account with Virginia Air Distributers.
 



Return to class listing
if ($_GET['info']) { ?> } } elseif (isset($_GET['class_id'])) { // show class info and signup button *************************************************************** // $query = "SELECT * FROM CLASS WHERE pkCLASS_ID = '".$_GET['class_id']."';"; $query = "SELECT *, COUNT(pkCLASS_SIGNUP_ID) AS COUNT FROM CLASS LEFT JOIN CLASS_SIGNUP ON pkCLASS_ID = fkCLASS_ID LEFT JOIN BRANCH b ON b.BRANCH_CODE = fkBRANCH_ID WHERE " . $division_where . " pkCLASS_ID = '" . $_GET['class_id'] . "' GROUP BY pkCLASS_ID"; $result = mysql_query($query) or trigger_error('Could not select from class', FATAL); $sel = mysql_fetch_assoc($result); /* RNichols: New Code to add Division Name to class description page */ $rval = $sel['fkDR_CODE']; $charin = strpos($rval, '_'); $division = substr($rval, 0, $charin); $divquery = "SELECT * FROM DIVISION WHERE pkDIVISION_ID = '" . $division . "'"; $divresult = mysql_query($divquery) or trigger_error('Could not select from division', FATAL); $divsel = mysql_fetch_assoc($divresult); /* end new code */ ?>
Class Number: TS42 11-29-18
Class Title: Rooftop Startup and Controls
Division:
Branch Number: TS42
Type: Onsite
Location: if ((strpos(strtolower($sel["LOCATION"]), "http://") !== false || strpos(strtolower($sel["LOCATION"]), "https://") !== false)) { echo "" . $sel['LOCATION'] . ""; } else { echo $sel['LOCATION']; } ?>
URL: if ((strpos(strtolower($sel["URL"]), "http://") !== false || strpos(strtolower($sel["URL"]), "https://") !== false)) { echo "" . $sel['URL'] . ""; } else { echo $sel['URL']; } ?>
Phone Number: (513) 772-2600
Fax Number: (513) 772-5820
Description:
Contact Person: Greg Knipper
Instructor: Jim Isbell
Cost: Standard Dealer: $75.00
Liberties Plus Dealer: $Free
Class Size:
Start Date: November 29, 2018
End Date: November 29, 2018
Start Time: 08:00am
Total Class Hours: 4
NATE Course Number: 1225-0008



Return to class listing
} elseif (isset($_GET['signup_confirm'])) { // show signup confirmation *************************************************************** $query = "SELECT * FROM CLASS, CLASS_SIGNUP WHERE pkCLASS_ID = fkCLASS_ID AND pkCLASS_SIGNUP_ID = '" . $_GET['signup_confirm'] . "'"; $result = mysql_query($query) or trigger_error("Search failed.. $query", FATAL); $row = mysql_fetch_assoc($result); ?>
Thank You. You have been signed up for the following class:
Class Number:
Class Title:
Class Date: December 31, 1969
Class Location:
URL:
Class Description:



Return to Class listing

An independent distributor of York, Virginia Air proudly supports the following major brands: