max

<html>

<head>
  <title>Pembayaran Hutang Customer</title>
</head>

<body>

<?php

        include("connect.php");
        //include("hari.php");

        //$hari = array('Senin ','Selasa ','Rabu ','Kamis ','Jumat ','Sabtu ','Minggu');
        //$hariIni =

        $bulan = date("F");
        $tanggal = date("m-D");
        $date = date("Y-m-d");
        $idAS = $_POST['pilihCS'];

         $sql = "SELECT FROM detail_hutang_customer as d , master_customer as m where " .
                 "d.id_customer = m.id_customer AND d.id_customer = '$idAS' " .
                  "ORDER BY d.id_pembayaran as idmax  ";
         $result = mysql_query($sql);
         $data = mysql_fetch_array($result);

         $dataID = $data['idmax'];

         $dataIDNew = (int) substr($dataID, 3, 4);
         $dataIDNew++;

         $noPemb = 'PMB' . sprintf("%04s", $dataIDNew);


        echo "<form action='proses/doPembayaranHutang.php' method='POST'>";
         echo "<table align='center' border='0'>";
          echo "<tr bgcolor='iceblue'>";
           echo "<td align='left' colspan='2'>
                    <font face='verdana' color='white' >No Pembayaran </br> $noPemb</td>
                    <input type='hidden' name='noPemb' value='$noPemb'>";
           echo "<td align='right' colspan='2'>
                    <font face='verdana' color='white' size='5'>$bulan</font><br>
                    <font face='verdana' color='white' size='4'>$tanggal</font></td>
                    <input type='hidden' name='date' value='$date'>";
          echo "</tr>";
          echo "<tr bgcolor='iceblue'>";
           echo "<td align='left'><font face='verdana' color='white'>ID Customer</td>";
           echo "<td align='left'><font face='verdana' color='white'>Nama</td>";
           echo "<td align='left'><font face='verdana' color='white'>Total Hutang</td>";
           echo "<td align='left'><font face='verdana' color='white'>Total Pembayaran</td>";
          echo "</tr>";

        $nama = $_POST['pilihCS'];

        $sql = "SELECT * from master_customer where nama = '$nama' ";
        $result = mysql_query($sql)or
            die(mysql_error()."An error occured in SQL Query </br> Query: $sql");

        while ($line = mysql_fetch_row($result)) {

            $id = $line[0];
            $nama = $line[1];
            $totalHutang = $line[2];

            echo "<tr bgcolor='iceblue'>";
             echo "<td align='center'><font face='verdana' color='white'>$id</td>";
             echo "<td align='center'><font face='verdana' color='white'>$nama</td>";
             echo "<td align='center'><font face='verdana' color='white'>$totalHutang</td>";
             echo "<td align='center'><input type='text' name='bayar'> </td>";
            echo "</tr>";

        }

            echo "<tr bgcolor='iceblue'>";
             echo "<td align='center' colspan='4'><input type='submit' value='bayar'> </td>";
            echo "</tr>";

         echo "</table>";
        echo "</form>";

?>

</body>

</html>