include("../admin/include/sql.php"); include('../admin/include/page_navigator.php'); $result_dealer_name_th = mysql_query("SELECT name_th FROM dealer_tb GROUP BY name_th"); $result_dealer_name_eng = mysql_query("SELECT name_eng FROM dealer_tb GROUP BY name_eng"); $result_dealer_province_th = mysql_query("SELECT province_th FROM dealer_tb GROUP BY province_th"); $result_dealer_province_eng = mysql_query("SELECT province_eng FROM dealer_tb GROUP BY province_eng"); $result_dealer_district_th = mysql_query("SELECT district_th FROM dealer_tb GROUP BY district_th"); $result_dealer_district_eng = mysql_query("SELECT district_eng FROM dealer_tb GROUP BY district_eng"); if(trim($_GET['name']) != ''){ $name = " (name_th LIKE '%".$_GET['name']."%' OR name_eng LIKE '%".$_GET['name']."%')"; if(trim($_GET['province']) != '' || trim($_GET['district']) != ''){ $name = " (name_th LIKE '%".$_GET['name']."%' OR name_eng LIKE '%".$_GET['name']."%') AND"; } } if(trim($_GET['province']) != ''){ $province = " (province_th LIKE '%".$_GET['province']."%' OR province_eng LIKE '%".$_GET['province']."%')"; if(trim($_POST['district']) != ''){ $province = " (province_th LIKE '%".$_GET['province']."%' OR province_eng LIKE '%".$_GET['province']."%') AND"; } } if(trim($_GET['district']) != ''){ $district = " (district_th LIKE '%".$_GET['district']."%' OR district_eng LIKE '%".$_GET['district']."%')"; } $q = "SELECT * FROM dealer_tb WHERE".$name.$province.$district." ORDER BY name_th ASC,name_eng ASC"; if(trim($_GET['province']) == '' && trim($_GET['district']) == '' && trim($_GET['name']) == ''){ $q = "SELECT * FROM dealer_tb ORDER BY name_th ASC,name_eng ASC"; } $qr=mysql_query($q); $total=mysql_num_rows($qr); $e_page=20; // กำหนด จำนวนรายการที่แสดงในแต่ละหน้า if(!isset($_GET['s_page'])){ $_GET['s_page']=0; }else{ $chk_page=$_GET['s_page']; $_GET['s_page']=$_GET['s_page']*$e_page; } $q.=" LIMIT ".$_GET['s_page'].",$e_page"; $qr=mysql_query($q); $num_rows = mysql_num_rows($qr); if(mysql_num_rows($qr)>=1){ $plus_p=($chk_page*$e_page)+mysql_num_rows($qr); }else{ $plus_p=($chk_page*$e_page); } $total_p=ceil($total/$e_page); $before_p=($chk_page*$e_page)+1; ?>

';}
if($row['repair'] == 'on'){$star2 = '
';}
echo '