UC知道php操作MYSQL出现错误
来源：百度知道 编辑：UC知道 时间：2024/05/21 07:24:33
$sql="insert into yupeng_list(user_name,yu_date,exchange_style,explain,exchange_num,balance)values('$user','$date','$inandout','$explain','$num','$balance')";
$result=mysql_query($sql,$link)or die("数据库错误！".mysql_error());
提示语法错误，不知道哪儿错了，
数据库错误！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 'explain,exchange_num,balance)values('kekenaer','1998-5-6','income','gggggggggggg' at line 1
$result=mysql_query($sql,$link)or die("数据库错误！".mysql_error());
提示语法错误，不知道哪儿错了，
数据库错误！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 'explain,exchange_num,balance)values('kekenaer','1998-5-6','income','gggggggggggg' at line 1
explain 是mysql 的关键字
把 explain 换成 `explain` 多两个符号
建议你把 explain 字段 换成其他名字
应该是语法错误
你这样试下:
在“$result=.................”上面一行，增加
die($sql);
来返回结果，我帮你看下