Question

php sql更新字段

mysql_select_db("data", $con);
$id = '1';
$fs="SELECT avg(atid_fs) FROM article_fs where aitd='$id'";
$query=mysql_query($fs);
mysql_query("UPDATE avg_fs SET avgscore = '平均分' WHERE id = '$id'");
while($row=mysql_fetch_array($query))
{
echo number_format($row['0'],1);
}
我想把表article_fs相应ID求出平均后，然后在表avg_fs找到相对应id更新avgscore这个字段，请问一下平均分处应该填写什么？谢谢！

Answer 1

php sql更新字段
while ($row = mysql_fetch_array($query)){
mysql_query("UPDATE avg_fs SET avgscore = '$row['avg']' WHERE id = '$id'");
}

Answer 2

while ($row = mysql_fetch_array($query)){
mysql_query("UPDATE avg_fs SET avgscore = '$row['avg']' WHERE id = '$id'");
}

追问

'$row['avg']' 这种写法提示错误

追答

"UPDATE avg_fs SET avgscore= ".$row['avg']." WHERE id = '$id";