= 0) GROUP BY to_vt_name"; } else{ $sql = "SELECT trim(to_vt_name) as to_vt_name, SUM(to_standartchg+to_flazzreceived+to_penaltychg+to_overnightchg) AS income FROM `transout` WHERE LEFT(to_datetimeout,10) = DATE_FORMAT(NOW(),'%Y-%m-%d') and siteid = '$siteid' and to_datetimeout < date_add(now(),interval -4 minute) GROUP BY to_vt_name"; } //echo $sql; //echo $sql; if($siteid != '526'){ $rs = mysqli_query($conn2, $sql); } else{ $rs = mysqli_query($conn, $sql); } $total = 0; $total2 = 0; $to_type = ''; $table = ""; $table .= ""; while ($data = mysqli_fetch_array($rs)) { $to_type .= '"' . $data['to_vt_name'] . '",'; //echo $data['income']; $total .= $data['income'] . ','; $total2 += $data['income']; if ($data['income'] > 0) { $table .= ''; $table .= "'; } } $table .= "

JENIS KENDARAAN	NOMINAL
' . $data['to_vt_name'] . '	" . number_format($data['income']) . '
TOTAL	" . number_format($total2) . '

'; ?>