function get_web_skus_by_type_and_brand($type_id, $brand_id) { $array = array(); $get_web_skus = mysql_query("SELECT web_sku_products.*, products.* FROM web_sku_products INNER JOIN products ON web_sku_products.product_id = products.product_id WHERE products.type_id = '$type_id' && products.brand_id = '$brand_id' GROUP BY web_sku_products.web_sku_id", $this->conn) or die(mysql_error()); while($web_skus = mysql_fetch_array($get_web_skus)) { $web_sku_id = $web_skus['web_sku_id']; $array = $this->get_web_skus("SELECT * FROM web_skus WHERE web_sku_id = '$web_sku_id'") + $array; } return $array; } function get_web_skus($query) { $get_web_skus = mysql_query($query, $this->conn) or die(mysql_error()); if(mysql_num_rows($get_web_skus)) { $array = array(); while($web_skus = mysql_fetch_array($get_web_skus)) { $array[$web_sku_id]['title'] = $web_skus['title']; $array[$web_sku_id]['price'] = $web_skus['price']; $array[$web_sku_id]['savings'] = $web_skus['savings']; } return $array; } else { return; } } function display_product_box($products_array, $web_skus_array) { $display = ''; if(isset($products_array)) { foreach($products_array as $product_id => $product) { $display .= "
\"".$product['product']."\" Compatible ".$this->get_type($product['type_id'])." cartridge

REF #: ".$product['ref']."
PART #: ".$product['product']."
COLOR: ".$product['color']."
".number_format($product['price'], 2)."\$
QTY:
"; } } if(isset($web_skus_array)) { foreach($web_skus_array as $web_sku_id => $web_sku) { $display .= "
\"".$web_sku['title']."\" ".$web_sku['title']."

"; foreach($web_sku['products'] as $web_sku_product_id => $web_sku_product) { $display .= "".$web_sku_product['quantity'] ." x ". $web_sku_product['product']." ".$web_sku_product['color']."
"; } $display .= "
".number_format($web_sku['price'], 2)."\$
QTY:
"; } } return $display; }