function doLookup()
{
$connect = new ConnectDB();
$db = $connect->Product_Database();
// Product Classes
$ProdClasses = $db->query("SELECT PRODUCT_CLASS_ID FROM PRODUCT_CLASSES_TABLE WITH(NOLOCK)");
$ProdClasses = $ProdClasses->fetchAllRows();
foreach ($ProdClasses as $k => $v) {
$Lookup['PRODUCT_CLASS_ID'][] = $v['PRODUCT_CLASS_ID'];
}
// Brand Names
$Brands = $db->query("SELECT DISTINCT(BRAND) AS BRANDS FROM INVENTORY_TABLE WITH(NOLOCK);");
$Brands = $Brands->fetchAllRows();
foreach ($Brands as $k => $v) {
$Lookup['BRANDS'][] = $v['BRANDS'];
}
// Vendor IDs
$Vendors = $db->query("SELECT VENDOR_ITEM_ID AS VENDORS FROM VENDOR_TABLE WITH(NOLOCK);");
$Vendors = $Vendors->fetchAllRows();
foreach ($Vendors as $k => $v) {
$Lookup['VENDORS'][] = $v['VENDORS'];
}
// Destroy actual lookups (Everything is in a different array)
unset($Vendors);
unset($Brands);
unset($ProdClasses);
return $Lookup;
}
