Code: Select all
//QUery the size items
$sqlquery = $this->db->query("SELECT pa.product_id, q.name, p.model, p.image, p.price, p.date_added FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description q ON (p.product_id = q.product_id) LEFT JOIN " . DB_PREFIX . "product_attribute pa ON (p.product_id = pa.product_id) WHERE pa.attribute_id = '36' AND text = '" . $resultSIZE[0]['text'] . "' AND (p.status = 1 AND p.quantity > 0)");//PRODUCT_ID");
$resultSIZE = $sqlquery->rows;
//Query the gender items
$sqlquery = $this->db->query("SELECT pa.product_id, q.name, p.model, p.image, p.price, p.date_added FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description q ON (p.product_id = q.product_id) LEFT JOIN " . DB_PREFIX . "product_attribute pa ON (p.product_id = pa.product_id) WHERE pa.attribute_id = '35' AND text = '" . $resultGENDER[0]['text'] . "' AND (p.status = 1 AND p.quantity > 0)");//PRODUCT_ID");
$resultGENDER = $sqlquery->rows;
//Compare the arrays and return the elements that are in each array
$new_products = array_intersect_key( $resultSIZE, array_unique( array_map('serialize' , $resultGENDER ) ) );
//Sort the array based on date added
array_multisort(array_column($new_products, 'date_added'), SORT_ASC, $new_products);
//Return the first three items
$new_products = array_slice($new_products, 0, 3);