seria algo como asi, revisalo a ver y adaptalo en caso de que lo necesites:
Código PHP:
Ver original<?php
$id = '1';
$query = mysql_query ("SELECT * FROM calificaciones WHERE id = '$id'",$conn); if($total >=1){
echo "<table width='100%'>";
echo "<tr><th>ID</th><th>Nombre</th><th>CalBio</th><th>ActBio</th><th>obsBio</th><th>calSoc</th><th>actSoc</th><th>obsSoc</th></tr>";
//calBio
if ($row['caliBio'] == '10'){
$calbi = 'Sobresaliente';
}elseif ($row['caliBio'] == '9'){
$calbi = 'Sobresaliente';
}elseif ($row['caliBio'] == '8'){
$calbi = 'Notable';
}elseif ($row['caliBio'] == '7'){
$calbi = 'Notable';
}elseif ($row['caliBio'] == '6'){
$calbi = 'Bien';
}elseif ($row['caliBio'] == '5'){
$calbi = 'Suficiente';
}else{
$calbi = 'Insuficiente';
}
//acbio
if ($row['actBio'] == '-'){
$acvi = 'Negativa';
}elseif ($row['actBio'] == "+"){
$acvi = 'Positiva';
}elseif ($row['actBio'] == 'PAS'){
$acvi = 'Pasiva';
}elseif ($row['actBio'] == 'MJR'){
$acvi = 'Mejorable';
}elseif ($row['actBio'] == 'N'){
$acvi = 'Normal';
}
//caliSoc
if ($row['caliSoc'] == '10'){
$cali = 'Sobresaliente';
}elseif ($row['caliSoc'] == '9'){
$cali = 'Sobresaliente';
}elseif ($row['caliSoc'] == '8'){
$cali = 'Notable';
}elseif ($row['caliSoc'] == '7'){
$cali = 'Notable';
}elseif ($row['caliSoc'] == '6'){
$cali = 'Bien';
}elseif ($row['caliSoc'] == '5'){
$cali = 'Suficiente';
}else{
$cali = 'Insuficiente';
}
//acSoc
if ($row['actSoc'] == '-'){
$ac = 'Negativa';
}elseif ($row['actSoc'] == "+"){
$ac = 'Positiva';
}elseif ($row['actSoc'] == 'PAS'){
$ac = 'Pasiva';
}elseif ($row['actSoc'] == 'MJR'){
$ac = 'Mejorable';
}elseif ($row['actSoc'] == 'N'){
$ac = 'Normal';
}
{
echo "<tr>
<td>".$row['id']."</td>
<td>".$row['nombre']."</td>
<td>".$calbi."</td>
<td>".$acvi."</td>
<td>".$row['obsBio']."</td>
<td>".$cali."</td>
<td>".$ac."</td>
<td>".$row['obsSoc']."</td>
</tr>";
}
echo "</table>";
} else {
echo "No hay registros que mostrar";
}
?>