have error in php or sql...help me...
Posted: Mon Sep 19, 2011 8:41 pm
this php code have the error when submit data to update...the error message like : Data Profil tidak dapat dicapai.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 'desc='anign',type='q' WHERE n_penyakit='angin'' at line 1...help me to solve this problem...
<?php
session_start();
include 'config.php';
$n_penyakit=$_POST["n_penyakit"];
$desc=$_POST["desc"];
$type=$_POST["type"];
$query="UPDATE penyakit SET n_penyakit='$n_penyakit',desc='$desc',type='$type' WHERE n_penyakit='$n_penyakit'";
$result=mysql_query($query) or die ('Data Profil tidak dapat dicapai.'.mysql_error());
?>
<?php
session_start();
include 'config.php';
$n_penyakit=$_POST["n_penyakit"];
$desc=$_POST["desc"];
$type=$_POST["type"];
$query="UPDATE penyakit SET n_penyakit='$n_penyakit',desc='$desc',type='$type' WHERE n_penyakit='$n_penyakit'";
$result=mysql_query($query) or die ('Data Profil tidak dapat dicapai.'.mysql_error());
?>