如何在php中应用多个数据？

Question

我有我的工作，但仍然有错误，请帮助我…

if(isset($_POST['add']))
{
$id=$_POST['id'];
                $bfcp=$bfcp=$_POST['bfcp'];
                $casualwear=$_POST['casualwear'];
                $popularity=$_POST['popularity'];
                $formalwear=$_POST['formalwear'];
                $talent=$_POST['talent'];
                $questionandanswer=$_POST['questionandanswer'];
                $Total= $bfcp + $casualwear + $popularity + $formalwear + $talent + $questionandanswer;
$sql="INSERT INTO criteria (id, bfcp, casualwear, popularity, formalwear, talent, questionandanswer, Total)
values('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total')
,('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total')";mysql_query($sql,$conn)or die(mysql_error());

}

帮帮我……

Answer 1

使用此

您的查询在下面使用了wrong.Please

if(isset($_POST['add']))
{
$id=$_POST['id'];
                $bfcp=$bfcp=$_POST['bfcp'];
                $casualwear=$_POST['casualwear'];
                $popularity=$_POST['popularity'];
                $formalwear=$_POST['formalwear'];
                $talent=$_POST['talent'];
                $questionandanswer=$_POST['questionandanswer'];
                $Total= $bfcp + $casualwear + $popularity + $formalwear + $talent + $questionandanswer;
$sql="INSERT INTO criteria (id, bfcp, casualwear, popularity, formalwear, talent, questionandanswer, Total)
values('$id','$bfcp','$casualwear','$popularity','$formalwear','$talent','$questionandanswer','$Total'");
mysql_query($sql,$conn)or die(mysql_error());

}