$Pesan = "";

 $sSQL = "SELECT caleg_id , caleg_name FROM tb_caleg WHERE trim(mobile_1) ='".trim($r[sendernumber])."' or ";

 $sSQL = $sSQL." trim(mobile_2) ='".trim($r[sendernumber])."' or ";

 $sSQL = $sSQL." trim(mobile_3) ='".trim($r[sendernumber])."' limit 1 ";

 $rslt=mysql_query($sSQL) or die ("error query3");

 $i=0;

 while ($row=mysql_fetch_assoc($rslt))

 {

 $caleg_id = $row['caleg_id'];

 $caleg_name = $row['caleg_name'];

 

 $sSQL3 = "";

 $sSQL3 = " SELECT IF(dk.fl_memilih=1,'MENDUKUNG','TDK MENDUKUNG') AS IsActive , ";

 $sSQL3 = $sSQL3." dk.dapil_id,COUNT(dk.fl_memilih) AS total , d.dapil_name ";

 $sSQL3 = $sSQL3." FROM tb_dukungan dk ";

 $sSQL3 = $sSQL3." INNER JOIN tb_dapil d ON dk.dapil_id = d.dapil_id ";

 $sSQL3 = $sSQL3." WHERE dk.caleg_id = '".$caleg_id."' AND dk.fl_active = 1 ";

 $sSQL3 = $sSQL3." GROUP BY dk.fl_memilih,dk.dapil_id ";

 $sSQL3 = $sSQL3." ORDER BY d.dapil_name , dk.fl_memilih";

 

 

 

 $rslt3=mysql_query($sSQL3) or die ("error query4");

 

 $Pesan = "INFO DUKUNGAN: ".$caleg_name;

 

 while ($row3=mysql_fetch_assoc($rslt3))

 {

 $dapil_name = $row3['dapil_name'];

 $total = $row3['total'];

 $IsActive = $row3['IsActive'];

 $Pesan = $Pesan." , (DAPIL =".$dapil_name.", ".$IsActive." = ".$total.") ";

 }