我正在编写以下代码
$query_upload="INSERT INTO sipat ('visit','date','meeting_detail','issues','details2','school','toilets','photo','water','connection','contract','news','currentdate') VALUS ('$visit','$date','$meeting_detail','$issues','$details2',$school,$toilets,$photo,$water,$connection,$contract,'$news','$currdate' )";
mysql_query($query_upload) or die("error in query == ----> ".mysql_error());
但是出错了查询错误===---->
您的SQL语法有错误；查看与MariaDB服务器版本对应的手册，了解第1行"visit"、"date"、"meeting_detail"、"issues"、"details2"、"school"、"oilets"、"photo"附近使用的正确语法
这是由于每个字段名称周围都有单引号"。您可以使用``或只删除引号。
$query_upload = "INSERT INTO sipat (`visit`,`date`,`meeting_detail`,`issues`,`details2`,`school`,`toilets`,`photo`,`water`,`connection`,`contract`,`news`,`currentdate`) VALUES ('".$visit."','".$date."','".$meeting_detail."','".$issues,"','".$details2."','".$school."', .'"$toilets."', '".$photo."', '".$water."', '".$connection."', '".$contract."', '".$news."', '".$currdate."' )";