Php向mysql增加数据_PHP如何向MYSQL添加数据问题

require_once("./data/conn.php");

$movie_name = $_POST['movie_name'];

$movie_category = $_POST['movie_category'];

$movie_direct = $_POST['movie_direct'];

$movie_write = $_POST['movie_write'];

$movie_star = $_POST['movie_star'];

$movie_language = $_POST['movie_language'];

$movie_images = $_POST['movie_images'];

$movie_stem = $_POST['movie_stem'];

$movie_screendate = $_POST['movie_screendate'];

$movie_adddate = $_POST['movie_adddate'];

$movie_updatedate = $_POST['movie_updatedate'];

$movie_spotfrequency = $_POST['movie_spotfrequency'];

$movie_scanfrequency = $_POST['movie_scanfrequency'];

$movie_summary = $_POST['movie_summary'];

$movie_address = $_POST['movie_address'];

$exec = "INSERT INTO mvoie_content(moviename,category,direct,write,star,language,images,stem,screendate,adddate,updatedate,spotfrequency,scanfrequency,summary,address) VALUES ('$movie_name','$movie_category','$movie_direct','$movie_write','$movie_star','$movie_language','$movie_images','$movie_stem','$movie_screendate','$movie_adddate','$movie_updatedate','$movie_spotfrequency','$movie_scanfrequency','$movie_summary','$movie_address')";

$quer = mysql_query($exec);

if ($quer){

die('数据添加成功.');

}else{

die('数据添加失败.');

}

mysql_close($conn);

?>

为什么添加不了..不知道哪里出错了~!请大家帮帮忙.

echo "$exec";

在SQL运行提示:

#1064 - 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 'write,star,language,images,stem,screendate,adddate,updatedate,spotfrequency,scan' at line 1

展开