250"; }else{ $price = " and p.products_price BETWEEN ".$price; } } $sql_products = "select p.* from tbl_products as p WHERE p.qty > 0 AND p.show_status=1 $keyword1 $stone_type1 $price Order By p.products_price "; //}else{ $sql_products = "select * from tbl_products where 1 $stone_type1";} //echo $sql_products; $result_products_rows = mysql_query($sql_products) or die(mysql_error(). " " . mysql_errno()); $tot_rows = mysql_num_rows($result_products_rows); mysql_free_result($result_products_rows); $pagelinks = paginate($limit, $tot_rows); $sql_products .= " LIMIT $start, $limit"; $result_products = mysql_query($sql_products) or die(DB_QUERY_ERROR); ?> TITLE
Search Products For ' '
By Product : By Price : By Stone :