tlong slesaikan masalah php script update

[nixsham]

<?php
session_start();

include('../../common/connJPN.php');
$hostname_connJPN = 'localhost'; // Host name
$username_connJPN = 'root'; // Mysql username
$password_connJPN = ''; // Mysql password
$database_connJPN = 'doktor'; // Database name


// Connect to server and select database.
mysql_connect($hostname_connJPN, $username_connJPN, $password_connJPN)or die(mysql_error());
mysql_select_db($database_connJPN)or die(mysql_error());

// update data in mysql database
$IdWarga='';
$negara='';
$sql="UPDATE warganegara SET IdWarga='IdWarga', negara='negara' WHERE IdWarga='IdWarga'";

$result = mysql_query($sql) or die (mysql_error());
// if successfully updated.
if ($result)
{
echo "<script>alert('Maklumat anda berjaya dikemaskini.')document.location.href = add_warganewAdmin.php'</script>";
}
else
{
echo "<script>alert('Maklumat anda tidak berjaya dikemaskini.')document.location.href = 'add_warganewAdmin.php'</script>";
}
mysql_close();
?>


result yg kluar page putih n db x di ubah...
otai programming tulun nix plz

[Eddyz-Kenpachi]

Ada kesilapan pada query update, sepatutnya :

$sql="UPDATE warganegara SET IdWarga= '" .$IdWarga. "', negara= '" .$negara. "' FROM <table_name> WHERE IdWarga= '" .$IdWarga. "'";

**Yg diboldkan hitam tuh, tukar kepada table name yg hendak diupdate. Yg biru tuh, cara guna variable yg telah anda declare.

Cuba query tuh, tgk menjadi x...Nnti update kat sini...

[nixsham]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM warganegara WHERE IdWarga='IdWarga'' at line 1

[Eddyz-Kenpachi]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM warganegara WHERE IdWarga='IdWarga'' at line 1

Sorry..Eddyz tersalah skit kat query tuh, nih edit balik yg btul :-

$sql="UPDATE warganegara SET IdWarga= '" .$IdWarga. "', negara= '" .$negara. "' FROM <table_name> WHERE IdWarga= '" .$IdWarga. "'";