数据库名: game_download 表名:basic 想更新字段名:click_count
有如下语句:@ $db=new mysqli('localhost','download','download123','game_download'); //实例化对象,建立连接
$db->query("set names 'GBK' ");
if(mysqli_connect_error()) //检测连接是否有误
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
} $id=$_GET['id'];
$query = "SELECT * FROM `basic` WHERE id =".$id;
$result=$db->query($query); $row=$result->fetch_assoc();
$click_count=$row['click_count']+1;
$update="UPDATE `basic` SET click_count=".$click_count."WHERE id=".$id;
$db->query($update);
有如下语句:@ $db=new mysqli('localhost','download','download123','game_download'); //实例化对象,建立连接
$db->query("set names 'GBK' ");
if(mysqli_connect_error()) //检测连接是否有误
{
echo 'Error: Could not connect to database. Please try again later.';
exit;
} $id=$_GET['id'];
$query = "SELECT * FROM `basic` WHERE id =".$id;
$result=$db->query($query); $row=$result->fetch_assoc();
$click_count=$row['click_count']+1;
$update="UPDATE `basic` SET click_count=".$click_count."WHERE id=".$id;
$db->query($update);
echo $click_count; //是否正确?
$update="UPDATE `basic` SET click_count=".$click_count." WHERE id=".$id; //WHERE前面少一个空格
if (!$db->query($update)) die($db->error);
比如 $update="UPDATE `basic` SET click_count=".$click_count."WHERE id=".$id;
在 WHERE 前就少了个空格象你这用的操作是不必要的,只需
$id=$_GET['id'];
$update = "UPDATE `basic` SET click_count=click_count+1 WHERE id=$id";
$db->query($update);
$update="UPDATE `basic` SET click_count=click_count+1 WHERE id=".$id;
少一部查询
具体什么错还是需要三楼说的输出下语句
SET col=col+1WHERE //col+1WHERE还是colo+1 WHERE