我有我的工作,但仍然错误plz帮助我…
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());
}
Plzz帮我…
使用此
您的查询是错误的。请使用以下
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());
}