ceritanya begini ane kan bikin form nomor urut harian berdasarkan tanggal,masalahnya kok kode urutnya ngak mau update secara otomatis dan muncul pesan : Duplicate entry '2014-07-03' for key 1
<?php
include("koneksi.php");
mysql_connect("localhost","root","root") or die("Gagal Akses Server");
mysql_select_db("rumkit_dkt") or die("Gagal Akses Database");
$hari_ini=date("Y-n-j");
$query="SELECT tanggal,no_registrasi FROM registrasi_pasien WHERE tanggal='$hari_ini' LIMIT 1";
$result=mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result)>0)
{
$row=mysql_fetch_array($result);
$no_registrasi=$row['no_registrasi'];
$query="UPDATE registrasi_pasien set no_registrasi=no_registrasi+1 WHERE tanggal='$hari_ini' LIMIT 1";
mysql_query($query) or die(mysql_error());
}
else
$no_registrasi=1;
if($submit){
$no_registrasi = $_POST['txtNo_registrasi'];
$tglperiksa = $_POST['thn']."-".$_POST['bln']."-".$_POST['tgl'];
$poskes_no = $_POST['txtPoskes_no'];
$namapasien = $_POST['txtNamapasien'];
$umur = $_POST['txtUmur'];
$alamat = $_POST['txtAlamat'];
$keluhan = $_POST['txtKeluhan'];
include "koneksi.php";
$tgllahir=$_POST['thn']."-".$_POST['bln']."-".$_POST['tgl'];
$query="INSERT INTO registrasi_pasien(tanggal,no_registrasi,tglperiksa,poskes_no,namapasien,umur,alamat,keluhan) VALUES('$hari_ini',1,'$tglperiksa','$poskes_no','$namapasien','$umur','$alamat','$keluhan')";
mysql_query($query) or die(mysql_error());
}
if(strlen($no_registrasi)<2) $no_registrasi="0".$no_registrasi;
$simpan=mysql_query($sql,$koneksi);
mysql_close($koneksi);
?><head>
<title>FORM REGISTRASI PASIEN</title>
</head>
<form method="post" action="registrasipasienn.php">
<table border="0">
<tr><td>No Registrasi</td>
<td>:</td><td><input type="text" readonly="" name="txtNo_registrasi" value="<?php echo $no_registrasi; ?>"></td></tr>
<tr><td>Tanggal Periksa</td><td>:</td>
<td><select name="tgl" size="1" id="tgl">
<?php
for ($i=1;$i<=31;$i++)
{
echo "<option value=".$i.">".$i."</option>";
}
?>
</select>
<select name="bln" size="1" id="bln">
<?php
$bulan=array("","Januari","Pebruari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
for ($i=1;$i<=12;$i++)
{
echo "<option value=".$i.">".$bulan[$i]."</option>";
}
?>
</select>
<select name="thn" size="1" id="thn">
<?php
for ($i=1900;$i<=2014;$i++)
{
echo "<option value=".$i.">".$i."</option>";
}
?>
</select></td>
</tr>
<tr><td>POSKES No </td>
<td>:</td><td><input type="text" name="txtPoskes_no" size="25"></td></tr>
<tr><td>Nama Pasien </td>
<td>:</td><td><input type="text" name="txtNamapasien" size="40"></td></tr>
<tr><td>Umur </td>
<td>:</td><td><input type="text" name="txtUmur" size="1"></td></tr>
<tr><td>Alamat </td>
<td>:</td><td><textarea name="txtAlamat" cols="30" rows="5" id="alamat"></textarea></td></tr>
<tr><td>Keluhan </td>
<td>:</td><td><textarea name="txtKeluhan" cols="30" rows="5" id="keluhan"></textarea></td></tr>
<tr><td></td><td></td><td><input type="submit" name="submit" value="Simpan"> <input type="reset" name="reset" value="Batal" /></td>
</tr><tr><td></td><td></td>
<td> </td>
</tr>
</table>
</form>
ane mohon banget bantuannya gan.
