This is the source.
I can add data but cannot edit or delete them.
It always tell me "Duplicate entry 'M001' for key 1"
help please
thanks
<?
$database="cdstore";
$hostname="localhost";
$username="hilma76";
$password="abc";
$db=mysql_connect($hostname,$username,$password);
mysql_select_db($database,$db);
if($action_type="ADD")
{
$sql="insert into barang(kode_brg,nama_brg,jenis,harga,stock) values('$kode_brg','$nama_brg','$jenis',$harga,$stock)";
if(! mysql_query($sql,$db))
{
echo mysql_error();
exit();
}
echo ("Barang sudah ditambahkan ke table");
}
elseif ($action_type= "Edit")
{
$sql="update barang set nama_brg='$nama_brg' jenis='$jenis' harga=$harga stock=$stock where kode_brg='$kode_brg'";
if(! mysql_query($sql,$db))
{
echo mysql_error();
exit();
}
echo ("Data telah terupdate");
}
elseif ($action_type="DELETE")
{
$sql="delete from barang where kode_brg='$kode_brg'";
if(!mysql_query($sql,$db))
{
echo mysql_error();
exit();
}
echo("Data telah terhapus");
}
?>
