0) { if ($flt != "") $flt = $flt." and "; $flt .= " p.man_id = ".$clean['man_id']; }; if ($clean['price_from'] > 0) { if ($flt != "") $flt = $flt." and "; $flt = $flt." p.price >= ".$clean['price_from']." and p.for_sale=1 "; } if ($clean['price_to'] > 0) { if ($flt != "") $flt = $flt." and "; $flt = $flt." p.price <= ".$clean['price_to']." and p.for_sale=1 "; } if ($clean['for_sale'] == "on"||$clean['for_sale'] == "1") { if ($flt != "") $flt = $flt." and "; $flt = $flt." p.for_sale = 1 and p.price > 0 "; } if ($clean['year_from'] > 0) { if ($flt != "") $flt = $flt." and "; $flt = $flt." p.prod_year >= ".$clean['year_from']." "; } if ($clean['year_to'] > 0) { if ($flt != "") $flt = $flt." and "; $flt = $flt." p.prod_year <= ".$clean['year_to']." "; } if ($clean['coldisp'] == 1) { if ($flt != "") $flt = $flt." and "; $flt = $flt." phone_id in ( select distinct(PHONE_ID) from PHONE_DETAILS where detail_id = 13 and property_detail <> '2' ) "; } if ($clean['coldisp'] == 2) { if ($flt != "") $flt = $flt." and "; $flt = $flt." phone_id in ( select distinct(PHONE_ID) from PHONE_DETAILS where detail_id = 13 and property_detail = '2') "; } if ($clean['body_type'] != 0) { if ($flt != "") $flt = $flt." and "; $flt = $flt." phone_id in ( select distinct(PHONE_ID) from PHONE_DETAILS where detail_id = ".$clean['body_type'] .")" ; } if ($clean['phone_nm'] != '') { if ($flt != "") $flt = $flt." and "; $flt = $flt." " .make_like_statement($clean['phone_nm'],"concat(p.phone_nm,m.man_nm)"); } $detailIds = array(34); if (isset($_GET['poly'])) $detailValues[1] = $_GET['poly']; else $detailValues[1] = 0; $detailIds[1] = 15; if (isset($_GET['java'])) $detailValues[3] = $_GET['java']; else $detailValues[3] = 0; $detailIds[3] = 11; if (isset($_GET['sensor'])) $detailValues[4] = $_GET['sensor']; else $detailValues[4] = 0; $detailIds[4] = 14; if (isset($_GET['camera'])) $detailValues[5] = $_GET['camera']; else $detailValues[5] = 0; $detailIds[5] = 12; if (isset($_GET['irda'])) $detailValues[6] = $_GET['irda']; else $detailValues[6] = 0; $detailIds[6] = 3; if (isset($_GET['bluetooth'])) $detailValues[7] = $_GET['bluetooth']; else $detailValues[7] = 0; $detailIds[7] = 1; if (isset($_GET['radio'])) $detailValues[8] = $_GET['radio']; else $detailValues[8] = 0; $detailIds[8] = 17; if (isset($_GET['mms'])) $detailValues[9] = $_GET['mms']; else $detailValues[9] = 0; $detailIds[9] = 19; if (isset($_GET['loudspeaker'])) $detailValues[10] = $_GET['loudspeaker']; else $detailValues[10] = 0; $detailIds[10] = 18; if (isset($_GET['pda'])) $detailValues[11] = $_GET['pda']; else $detailValues[11] = 0; $detailIds[11] = 24; if (isset($_GET['mp3'])) $detailValues[12] = $_GET['mp3']; else $detailValues[12] = 0; $detailIds[12] = 22; if (isset($_GET['email'])) $detailValues[13] = $_GET['email']; else $detailValues[13] = 0; $detailIds[13] = 23; if (isset($_GET['prot'])) $detailValues[14] = $_GET['prot']; else $detailValues[14] = 0; $detailIds[14] = 25; if (isset($_GET['wlan'])) $detailValues[15] = $_GET['wlan']; else $detailValues[15] = 0; $detailIds[15] = 54; if (isset($_GET['usb'])) $detailValues[16] = $_GET['usb']; else $detailValues[16] = 0; $detailIds[16] = 6; if (isset($_GET['ptt'])) $detailValues[17] = $_GET['ptt']; else $detailValues[17] = 0; $detailIds[17] = 53; if (isset($_GET['tv'])) $detailValues[18] = $_GET['tv']; else $detailValues[18] = 0; $detailIds[18] = 73; if (isset($_GET['vdial'])) $detailValues[19] = $_GET['vdial']; else $detailValues[19] = 0; $detailIds[19] = 26; if (isset($_GET['vcommand'])) $detailValues[20] = $_GET['vcommand']; else $detailValues[20] = 0; $detailIds[20] = 27; if (isset($_GET['edge'])) $detailValues[21] = $_GET['edge']; else $detailValues[21] = 0; $detailIds[21] = 38; if (isset($_GET['calc'])) $detailValues[22] = $_GET['calc']; else $detailValues[22] = 0; $detailIds[22] = 30; if (isset($_GET['dict'])) $detailValues[23] = $_GET['dict']; else $detailValues[23] = 0; $detailIds[23] = 31; if (isset($_GET['org'])) $detailValues[24] = $_GET['org']; else $detailValues[24] = 0; $detailIds[24] = 32; if (isset($_GET['alarm'])) $detailValues[25] = $_GET['alarm']; else $detailValues[25] = 0; $detailIds[25] = 33; if (isset($_GET['clock'])) $detailValues[26] = $_GET['clock']; else $detailValues[26] = 0; $detailIds[26] = 34; if (isset($_GET['cal'])) $detailValues[27] = $_GET['cal']; else $detailValues[27] = 0; $detailIds[27] = 35; if (isset($_GET['gprs'])) $detailValues[28] = $_GET['gprs']; else $detailValues[28] = 0; $detailIds[28] = 39; if (isset($_GET['dual_sim'])) $detailValues[29] = $_GET['dual_sim']; else $detailValues[29] = 0; $detailIds[29] = 72; if (isset($_GET['htmlbr'])) $detailValues[30] = $_GET['htmlbr']; else $detailValues[30] = 0; $detailIds[30] = 37; if (isset($_GET['umts'])) $detailValues[31] = $_GET['umts']; else $detailValues[31] = 0; $detailIds[31] = 58; if (isset($_GET['video'])) $detailValues[32] = $_GET['video']; else $detailValues[32] = 0; $detailIds[32] = 55; if (isset($_GET['flash'])) $detailValues[33] = $_GET['flash']; else $detailValues[33] = 0; $detailIds[33] = 57; if (isset($_GET['memory_card_slot'])) $detailValues[34] = $_GET['memory_card_slot']; else $detailValues[34] = 0; $detailIds[34] = 60; ////////////////////////////////////////////////////////// foreach($detailValues as $key => $detailValue) { $detailId = $detailIds[$key]; if ($detailValue == 1) { if ($flt != "") $flt = $flt." and "; $flt = $flt." phone_id in ( select distinct(PHONE_ID) from PHONE_DETAILS where detail_id = ".$detailId .")" ; } if ($detailValue == 2) { if ($flt != "") $flt = $flt." and "; $flt = $flt." phone_id not in ( select distinct(PHONE_ID) from PHONE_DETAILS where detail_id = ".$detailId .")" ; } } //echo($flt); if ($clean['result_cnt']=='') { $cnt = query_into_value("select count(*) CNT from PHONES p, MANUFACTURERS m where $flt"); } else { $cnt = $clean['result_cnt']; } if ($clean['orderbyid']=='1') $orderby_str = 'p.price asc'; if ($clean['orderbyid']=='2') $orderby_str = 'p.price desc'; if ($clean['orderbyid']=='3') $orderby_str = 'p.creation_dt asc'; if ($clean['orderbyid']=='4') $orderby_str = 'p.creation_dt desc'; if ($clean['orderbyid']=='5') $orderby_str = 'p.phone_nm asc'; if ($clean['orderbyid']=='6') $orderby_str = 'p.phone_nm desc'; $res_prod_list = query_into_result("select * from PHONES p, MANUFACTURERS m where $flt order by m.man_nm, $orderby_str limit $startRow, $page_size"); } if ($clean['type']=='mymarket') { $flt_mymarket = " shop_id = 27 and p.status_id = 1 and p.end_dt > now()"; if ($clean['category_id']!="") $flt_mymarket .= ' and p.category_id in (' . $clean['category_id']. ' )'; if ($clean['price_from']!="") $flt_mymarket .= " and p.price_value>=$price_from"; if ($clean['price_to']!="") $flt_mymarket .= " and p.price_value<=$price_to"; //if ($clean['phone_nm']!="") $flt_mymarket .= " and " . make_like_statement(strtolower(remove_extra_spaces($product_nm)),'concat(p.product_nm,pd.product_desc)'); if ($clean['phone_nm']!="") $flt_mymarket .= " and p.product_nm like ('%$_GET[phone_nm]%') " ; if ($clean['result_cnt']=='') { $cnt = query_into_value("select count(*) CNT from mymarket.products p, mymarket.product_details pd where p.product_id = pd.product_id and " . $flt_mymarket); } else { $cnt = $clean['result_cnt']; } if ($clean['orderbyid']=='1') $orderby_str = 'p.price asc'; if ($clean['orderbyid']=='2') $orderby_str = 'p.price desc'; if ($clean['orderbyid']=='3') $orderby_str = 'p.create_dt asc'; if ($clean['orderbyid']=='4') $orderby_str = 'p.create_dt desc'; if ($clean['orderbyid']=='5') $orderby_str = 'p.product_nm asc'; if ($clean['orderbyid']=='6') $orderby_str = 'p.product_nm desc'; $res_prod_list = query_into_result("select p.user_id, p.product_id, p.photo, p.product_nm, p.price, pd.product_desc, day(p.update_dt) update_day, month(p.update_dt) month_id, p.show_order, p.update_dt, p.shop_id, p.currency_id from mymarket.products p, mymarket.product_details pd where p.product_id = pd.product_id and " . $flt_mymarket . " order by $orderby_str limit $startRow, $page_size" ); } ?>
  << $l_prev"; $pages_str.=" "; ?> $i"; $pages_str.=" "; } } ?> = ($cnt/$page_size)) $pages_str.="$l_next >>"; else $pages_str.="$l_next >>"; echo($pages_str); ///////////// end pages ?>
( ! ) Notice: Undefined variable: l_price_asc in C:\Program Files\VertrigoServ\www\prod_list.php on line 324
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
( ! ) Notice: Undefined variable: clean in C:\Program Files\VertrigoServ\www\prod_list.php on line 331
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
" id="oldOrderbyId" />
'); } else { echo(''); } $i=1; } if ($clean['type']=='mymobile') { $prod_nm = $row_prod_list['MAN_NM'] . " " . $row_prod_list['PHONE_NM']; $photo_url = "photos/".strtolower($row_prod_list["PHOTO"]); if (($row_prod_list["FOR_SALE"]==1)&&($row_prod_list["PRICE"]>0)) $prod_price=$row_prod_list["PRICE"]." ".$l_lari; else $prod_price = " "; $det_link = "product_details.php?type=mymobile&product_id=".$row_prod_list["PHONE_ID"]; $img_class = "mymobile_list_image"; } if ($clean['type']=='mymarket') { $prod_nm = $row_prod_list['product_nm']; if (my_htmlentities($row_prod_list["photo"])=="0") $photo_url="http://www.mymarket.ge/images/no_photo_w56.png"; if ($row_prod_list["photo"]!="0"&&$row_prod_list["shop_id"]!='') $photo_url="http://www.mymarket.ge/photos/shops/thumbs/".$row_prod_list["photo"]."_1.jpg"; $prod_price = $row_prod_list["price"]." ".$l_lari; $det_link = "product_details.php?type=mymarket&product_id=".$row_prod_list["product_id"]; $img_class = "mymarket_list_image"; } ?>
'.$row_prod_list['MAN_NM'].'
'.$row_prod_list['MAN_NM'].'
( ! ) Notice: Undefined variable: det_link in C:\Program Files\VertrigoServ\www\prod_list.php on line 379
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
">( ! ) Notice: Undefined variable: photo_url in C:\Program Files\VertrigoServ\www\prod_list.php on line 379
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
" alt="" />
( ! ) Notice: Undefined variable: det_link in C:\Program Files\VertrigoServ\www\prod_list.php on line 384
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
">
( ! ) Notice: Undefined variable: prod_nm in C:\Program Files\VertrigoServ\www\prod_list.php on line 384
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0

( ! ) Notice: Undefined variable: prod_price in C:\Program Files\VertrigoServ\www\prod_list.php on line 389
Call Stack
#TimeMemoryFunctionLocation
10.0000262656{main}( )...\prod_list.php:0
"); $i=1; } if ($clean['type']=='mymobile') $old_man_id = $row_prod_list['MAN_ID']; } ?>