<?php
$Kode_Cash = $_REQUEST['id'];
$sql = mysql_query("select * from belicash where Kode_Cash = '$Kode_Cash'");
$data = mysql_fetch_array($sql);

?>

<form name="update_data" action="update_cash.php" method="post">
<input type="hidden" name="Kode_Cash" value="<?php echo $id; ?>" />
    <table border="0" cellpadding="5" cellspacing="0">
    <tr bgcolor="#666666">
    <td colspan="4"><font color="#FFFFFF">PENGEDITAN DATA PEMBELIAN CASH</font></td>
    </tr>
      <tr>
        <td>Tanggal  </td>
        <td>:</td>
        <td colspan="2"><input name="TanggalCash" type="text" required value="<?php echo $data['TanggalCash']; ?>"></td>
      </tr>
      <tr>
        <td>Pelanggan</td>
        <td>:</td>
        <td width="157"><label>
          <select name="Kode_Pelanggan">
		  <option value=""></option>
	<?php
	$query_pelanggan = mysql_query("select Kode_Pelanggan,Nama from pelanggan");
	while ($data2=mysql_fetch_array($query_pelanggan)){
		if($data[Kode_Pelanggan]==$data2[Kode_Pelanggan])
	 		echo "<option value=$data2[Kode_Pelanggan] selected>$data2[Nama]</option>";
		else
	 		echo "<option value=$data2[Kode_Pelanggan]>$data2[Nama]</option>";
	}
	?>
          </select>
        </label></td>
        <td width="154"><a href="tambah_pelanggan.php">Tambah Pelanggan</a></td>
      </tr>
      <tr>
        <td>Merek mobil</td>
        <td>:</td>
		<td colspan="2">
<select name="Kode_Mobil">
		<option value=""></option>
		  <?php
		  $query = mysql_query("select * from mobil");
		  while($data3 = mysql_fetch_array($query)){
		  	if($data[Kode_Mobil]==$data3[Kode_Mobil]){
				echo "<option value=$data3[Kode_Mobil] selected>$data3[Merk] - Rp. $data3[Harga]</option>";
				}
				else{
					echo"<option value=$data3[Kode_Mobil]>$data3[Merk] - Rp. $data3[Harga]</option>";
				}
		  }
		  ?>
          </select></td>

      </tr>
        <td>Bayar</td>
        <td>:</td>
        <td colspan="2"><input name="Bayar" type="text" required value="<?php echo $data['Bayar']; ?>"></td>
      </tr>
      <tr>
        <td>Keterangan</td>
        <td>:</td>
        <td colspan="2"><input name="Keterangan" type="text" required value="<?php echo $data['Keterangan']; ?>"></td>
      </tr>
      <tr>
      	<td>&nbsp;</td>
        <td>&nbsp;</td>
        <td colspan="2"><input type="submit" name="submit" value="Simpan" /></td>
      </tr>
    </table>

</form>