i have php script:
<html>
<body>
<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("experiment",$conn);
$sql = "select * from student inner join study where student.nis=study.nis;
$result = mysql_query($sql) or die(mysql_error());
$average = ????
?>
<table cellpadding="7" cellspacing="0" border="1">
<tr>
<th>nis</th>
<th>name</th>
<th>class</th>
<th>math</th>
<th>english</th>
<th>physics</th>
<th>average</th>
</tr>
<?php while($val = mysql_fetch_array($result)){?>
<tr>
<td><?php echo $val['nis'];?></td>
<td><?php echo $val['name'];?></td>
<td><?php echo $val['class'];?></td>
<td><?php echo $val['math'];?></td>
<td><?php echo $val['english'];?></td>
<td><?php echo $val['physics'];?></td>
<td><?php echo ????? ;?></td>
</tr>
<?php }?>
</table>
</body>
</html>
how script for find average??
please help me?
