Class Number: Appreciation Day
Class Title: Customer Appreciation Day
Class Date: April 4, 2018
Class Location: 6892 W Snowville, Brecksville, OH, 44141
URL:
Class Description: 2018 Virginia Air Customer Appreciation Day. Come out for our customer appreciation day! Meet our branch associates and take a tour of our branch and warehouse! There will be plenty of door prizes and vendors present to answer any questions you may have about their products! Lunch will be provided. We look forward to seeing you there!
* 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: Appreciation Day
Class Title: Customer Appreciation Day
Division:
Branch Number: TS40
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: (440) 717-2170
Fax Number: (440) 717-2112
Description: 2018 Virginia Air Customer Appreciation Day. Come out for our customer appreciation day! Meet our branch associates and take a tour of our branch and warehouse! There will be plenty of door prizes and vendors present to answer any questions you may have about their products! Lunch will be provided. We look forward to seeing you there!
Contact Person: Patrick Frajter
Instructor: Patrick Frajter
Cost:
Class Size:
Start Date: April 4, 2018
End Date: April 4, 2018
Start Time: 11:00 AM
Total Class Hours: 0



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: