what´s wrong with this code??

[makexitxcount]

I´m trying to do a table linked with a mysql db, but i got a problem, i want the values only to appear when they´re tag "EstatTecnic" is different from "A".
First i couldn´t make the link "see" dissapear with their chained named on the left cell, the named dissapear but the "see" didn´t. They told me to change the code to what i post below, but it doesn´t work, somebody have a clue of what is going wrong? i uploaded a picture of what i want to have and what i have right now:

thnxs

<?
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
 if($row_rstTecnic['EstatTecnic']=="A"){
echo $row_rstTecnic['NomTecnic'].'</td><td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'">see</a></td>';
}else{
echo '</td><td></td>';
};
?>
</tr>
<?
};
?> </table>

[HalfaBee]

You need to add an opening <tr> and <td>

<? 
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){ 
    echo '<tr'>'
    if($row_rstTecnic['EstatTecnic']=="A"){ 
        echo '<td>',$row_rstTecnic['NomTecnic'].'</td><td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'">see</a></td>'; 
    }else{ 
        echo '</td><td></td>'; 
    } 
    echo "</tr>\n";
} 
?> 

[makexitxcount]

hey,
i´ve tried to change my part of the script for yours but it´s not working(it keeps writting ///';}else{echo '</td><td></td>';}echo "</tr>";}//// as text before the table) i think i´m putting it in the wrong place, could you show me where to put it. thnxs

 <table align="center"width="400" border="4" cellpadding="2" cellspacing="0" bordercolor="#FF3300" bgcolor="#FF6600" summary="Un Listado de todos los Tecnicos almacenados en la base de datos">
      <caption align="center" class="TEXTO2">
      Técnicos Base de Datos
      </caption>

<?
 while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
 if($row_rstTecnic['EstatTecnic']=="A") {
echo $row_rstTecnic['NomTecnic']."</td><td><a href='tecnic.php?tecnic=".$row_rstTecnic['NumTecnic']."'>see </a></td>"; 
}else{
echo '</td><td></td>';
};
?>
</tr>
<?
};
?> </table>

[HalfaBee]

<table align="center"width="400" border="4" cellpadding="2" cellspacing="0" bordercolor="#FF3300" bgcolor="#FF6600" summary="Un Listado de todos los Tecnicos almacenados en la base de datos"> 
      <caption align="center" class="TEXTO2"> 
      Técnicos Base de Datos 
      </caption> 
<? 
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){ 
    echo '<tr'>' 
    if($row_rstTecnic['EstatTecnic']=="A"){ 
        echo '<td>',$row_rstTecnic['NomTecnic'].'</td><td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'">see</a></td>'; 
    }else{ 
        echo '</td><td></td>'; 
    } 
    echo "</tr>\n"; 
} 
?> </table> 

[makexitxcount]

thnxs, but it keeps giving me the same problem, the last part of the code isn´t being recognised as code or something like that, instead of using it as code it´s just being written as text before the table.

this is the part not being recognized, i´ve been looking for the mistake but i cannot see what i´m doing wrong.

';
}else{
echo '</td><td></td>';
}
echo "</tr>\n";
}
?> </table>

[ashsumo]

HalfaBee wrote:

        echo '<td>'[b],[/b]$row_rstTecnic['NomTecnic'].'</td><td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'">see</a></td>';  

not sure if this is causing your problem but this line doesnt look correctly formatted

[HalfaBee]

yep a , instead of a .

[makexitxcount]

well, i´ve try it and it looks that this isn´t causing the problem cause it keeps the same way as it did before

[ashsumo]

the . marks the continuation of the echo command, so with the , rather than the . the rest of the echo command wouldn't be output correctly

[makexitxcount]

after changing the "," for the dot, this is the way that is looking right now:

[Skull]

does the page have a .php extension (or does your host even have php installed)? I bet if you look at the source code for the page you'll find that none of the php code is being ran, but instead just being outputted as plain text.

[ClarkF1]

There is a syntax error in the correction posted.

It should be:

echo '<tr>'; 

not

echo '<tr'>'