$sd = 1; } } $txtSearch = $_POST["txtSearch"]; if ($txtSearch != '') { //$where.=" AND (p.product_name REGEXP ('".mysql_real_escape_string($txtSearch).".*$') || p.product_description REGEXP ('".mysql_real_escape_string($txtSearch).".*$') )"; $where .= " AND (CONCAT(p.product_name, p.product_description) REGEXP ('" . mysql_real_escape_string($txtSearch) . ".*\$'))"; } if ($chkProductArtist == "1") { $where = ''; $where .= " AND (CONCAT(s.artist_name,s.first_name, s.last_name) REGEXP ('" . mysql_real_escape_string($txtSearch) . ".*\$'))"; //$where .= ' AND (s.artist_name LIKE "%'.mysql_real_escape_string($txtSearch).'%" || s.first_name LIKE "%'.mysql_real_escape_string($txtSearch).'%" || s.last_name LIKE "%'.mysql_real_escape_string($txtSearch).'%" || s.company LIKE "%'.mysql_real_escape_string($txtSearch).'%" ) '; } /*-------Multicart 2.0 Upgradation starts------*/ if ($ddlCategory == 'made-to-order') { $categorylist = implode(",", getCategoryDescendants(2)); $where .= " AND p.eMadetoOrder='Y' "; } if (isNotNull($categorylist)) { $where .= " AND p.product_category IN ({$categorylist}) "; } /*-------Multicart 2.0 Upgradation ends------*/ $sortBy = $_REQUEST['txtPriceSort']; $sql = "SELECT DISTINCT p.vapproved, p.product_id,po.product_option_id,(p.product_price+po.additional_price) AS product_price,po.image_small,po.product_stock,po.discount,p.eMadetoOrder,\n p.product_name,s.artist_name,p.eMadetoOrder,\n (SELECT pm.vimage_name FROM " . $tableprefix . "product_view_images pm where pm.nimage_productid=p.product_id LIMIT 0,1)AS smallimage\n FROM " . $tableprefix . "products p\n INNER JOIN " . $tableprefix . "product_options po ON po.product_id = p.product_id AND po.default_option = 'YES'\n INNER JOIN " . $tableprefix . "artists s ON p.product_artist_id = s.artist_id\n INNER JOIN " . $tableprefix . "categories c ON c.category_id = p.product_category\n WHERE p.deleted = 'N' AND p.vapproved='Y'\n AND s.vapproved='Y' AND s.deleted = 'N' AND s.plan_expired='N' AND s.vacationmode = 'N' \n AND po.product_stock > 0 AND c.vEnable='Y' "; if (getSettingsValue('product_listing_fee') > 0) { $sql .= " AND p.payment_status='COMPLETED' "; } $sql = $sql . $where; $ddlSelectedCategory = str_replace("'", "", stripslashes($ddlCategory)); if (!isset($pagenum)) { $pagenum = 1;
function getCategoryDescendants($catid) { global $tableprefix; static $option_results; static $i = 0; $option_results[$i] = $catid; $i++; /*---Mulicart 2.0 Upgradation-------*/ $sql = "SELECT category_id FROM `" . $tableprefix . "categories` where parent_id = " . $catid; $result = mysql_query($sql) or die(mysql_error()); /*---Mulicart 2.0 Upgradation-------*/ if (mysql_num_rows($result) != 0) { while ($row = mysql_fetch_array($result)) { getCategoryDescendants($row["category_id"]); } } return $option_results; }