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 .= "
|
Compatible ".$this->get_type($product['type_id'])." cartridge REF #: ".$product['ref']." PART #: ".$product['product']." COLOR: ".$product['color']." |
".number_format($product['price'], 2)."\$ |
![]() |
".$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)."\$ |