记录未更新 [英] record is not updating

问题描述

我已经尝试了很多来解决这个小问题...我正在尝试更新 PHPmyadmin 数据库中的记录.

I have tried a lot to solve this small problem...I am trying to update a record in PHPmyadmin database.

$query = 'UPDATE movie SET 
                    movie_name = "'.$_POST['movie_name'].'";
                    movie_year = '.$_POST['movie_year'].';
                    movie_type =   "'.$_POST['movie_type'].'";
                    movie_leadactor =  "'.$_POST['movie_leadactor'].'";
                    movie_director =  "'.$_POST['movie_director'].'";
                    movie_running_time = "'.$_POST['movie_time'].'";
                    movie_cost = "'.$_POST['movie_cost'].'";
                    movie_takings = "'.$_POST['movie_earn'].'"';

但是当我将此查询放入 sql 时，它显示错误.

but when I put this query in sql it shows an error.

这是我的简单查询.....

this is my simple query.....

UPDATE movie SET movie_name = "XXX"; movie_year = 2010; movie_type = "7"; movie_leadactor = "4"; movie_director = "6"; movie_running_time = "90 "; movie_cost = "6.0 "; movie_takings = "22.0 "

我该如何解决?请帮忙

错误发生在电影年.错误代码是 1064

error is on movie_year. error code is 1064

推荐答案

Why you are using ';' 而不是 ',' 分隔符....modify like用逗号分隔符 ','

Why you are using ';' instead of ',' seperator....modify like this with comma seperator ','

$query = 'UPDATE movie SET 
                movie_name = "'.$_POST['movie_name'].'",
                movie_year = '.$_POST['movie_year'].',
                movie_type =   "'.$_POST['movie_type'].'",
                movie_leadactor =  "'.$_POST['movie_leadactor'].'",
                movie_director =  "'.$_POST['movie_director'].'",
                movie_running_time = "'.$_POST['movie_time'].'",
                movie_cost = "'.$_POST['movie_cost'].'",
                movie_takings = "'.$_POST['movie_earn'].'"';

并尝试使用 'mysql_real_escape_string'

这篇关于记录未更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！