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; }