switch (floor(score / 10)) { case 0: case 1: case 2: case 3: case 4: case 5: result = '失败'; break; case 6: case 7: result = '通过'; break; case 8: result = '良好'; break; case 9: result = '优秀'; break; default: if (score == 100) result = '满分'; else result = 'error'; }
while($arr=mysql_fetch_array($result))
{
echo $arr['name'];
echo $arr['chengji'];
}
其中$arr[];这是从数据库中得到的数组,这是遍历数据库的基本方法
mysql_num_rows($result);是得到数据的条数
case 0:
case 1:
case 2:
case 3:
case 4:
case 5:
result = '失败';
break;
case 6:
case 7:
result = '通过';
break;
case 8:
result = '良好';
break;
case 9:
result = '优秀';
break;
default:
if (score == 100)
result = '满分';
else
result = 'error';
}