What´s wrong on this script?

[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:
[img]http://img155.imageshack.us/img155/1210/sinttulo1ql5.jpg[/img]
thnxs

[code=php:0]<?
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>[/code]

[ronverdonk]

Get rid of the semi colons after the closing accolades (twice):
[code]};
[/code]

Ronald  ;D

[makexitxcount]

thnxs, but it keeps without working

[king arthur]

You don't have any opening row or cell tags inside your while loop. Look at the code inside the loop - the first tag is a </td> - there is no corresponding opening <td> tag or even an opening <tr> tag. So your table is not complete, that's why it looks the way it does.

[Chetan]

There is a chance he might have a script above this, dun u think
but ther is no sarting for the TD in the beginning of the while, check that
and this is a php place where he made the mistake not html
[code]
<?
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>";
}
echo "</tr>";
}
?>
</table>
[/code]
*bumped*

[makexitxcount]

my problem was that when i tried to put a <table> or a <tr> tag between the php code didn´t recognized as html, so i put them at the top but it wasn´t working.
right now i´m working with an other script, but it keeps with the same problem.
[code=php:0]<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>
<?php
echo '<table>' ;
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
  echo '<tr>
              <td>', $row_rstTecnic['NomTecnic'] ,'</td>';
  if($row_rstTecnic['EstatTecnic']=="A"){
      echo '<td><a href="tecnic.php?tecnic=', $row_rstTecnic['NumTecnic'] ,'" title="View details for ', $row_rstTecnic['NomTecnic'] ,'">see</a></td>';
  }else{
      echo '</td>&nbsp;<td>';
  }
  echo '</tr>';
}
echo '</table>';
?>[/code]

[king arthur]

What you need to do is look at the source HTML that this code outputs, and then you will see where you are missing opening <tr> and <td> tags.

[Chetan]

I thik its a php mistake cause all the extra it displays is in PHP and not HTML

[code]
<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>
<table>
<?php
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
  echo ('<tr>
             <td>'. $row_rstTecnic['NomTecnic'] .'</td>');
  if($row_rstTecnic['EstatTecnic']=="A"){
      echo ('<td><a href="tecnic.php?tecnic='. $row_rstTecnic['NumTecnic'] .'" title="View details for '. $row_rstTecnic['NomTecnic'] .'">see</a></td>');
  }else{
      echo '</td>&nbsp;<td>';
  }
  echo '</tr>';
}
?>
</table>
[/code]

[ronverdonk]

Why did you replace all the concatenation dots by comma's ?
The following works fine:
[code]<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>
<?php
echo '<table>' ;
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
  echo '<tr><td>'.$row_rstTecnic['NomTecnic'].'</td>';
  if($row_rstTecnic['EstatTecnic']=="A"){
      echo '<td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'" title="View details for '.$row_rstTecnic['NomTecnic'].'">see</a></td></tr>';
  }
  else {
      echo '<td>&nbsp;</td></tr>';
  }
}
echo '</table>';
?>[/code]

Ronald  ;D

[Chetan]

I only replaced that part :) for him

[ronverdonk]

Sorry, the 2nd echo <table>  must go out.

Ronald

[makexitxcount]

[quote author=ronverdonk link=topic=102545.msg407125#msg407125 date=1154427748]
Sorry, the 2nd echo <table>  must go out.

Ronald

[/quote]
hey,thanks, that´s nearly what i wanted to do, now i only need the names on the left side to dissapear with the see too, if you can help me you´ll be my hero :)

[Chetan]

names on the left side, watcha mean

[makexitxcount]

The right side is the page that i have right now, i want the names on the left side of the table to dissapear too, as the image on the left, they disappear when the 'EstatTecnic' from the mysql db is different from A
[URL=http://img101.imageshack.us/my.php?image=sinttulo3jw3.jpg][IMG]http://img101.imageshack.us/img101/6936/sinttulo3jw3.th.jpg[/img][/URL]

thnxs

[ronverdonk]

Then why don't you take the following statement out?

[code]echo '<tr><td>'.$row_rstTecnic['NomTecnic'].'</td>';
[/code]

Ronald  ;D

[Chetan]

u meen to say that if EstatTecnic is different from A then the row should not be displayed? the here is wat 2 do
[code]
while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){
  echo '<tr><td>'.$row_rstTecnic['NomTecnic'].'</td>';
  if($row_rstTecnic['EstatTecnic']=="A"){
      echo '<td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'" title="View details for '.$row_rstTecnic['NomTecnic'].'">see</a></td></tr>';
  }
  else {
      echo '<td>&nbsp;</td></tr>';
  }
}
[/code]

to

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

or this incase you dont want to display names at all

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

[makexitxcount]

done now, thnxs for yout help!

[ronverdonk]

Now you make me curious, because I am still guessing what you really wanted! What solution did you use?

Ronald  ;D

[makexitxcount]

i did it like the second script that you post up there, and now it works fine

[Chetan]

u mean the one which dos not show at all?

[makexitxcount]

that´s what i did, maybe it has nothing to do with the one that you post, but when i saw it before, i thought it was the same (i need more sleep  ;D)
Here´s what i´ve finally done:
[code=php:0]  <?php

while ($row_rstTecnic = mysql_fetch_assoc($rstTecnic)){

  if($row_rstTecnic['EstatTecnic']=="A"){
        echo '<tr><td>'.$row_rstTecnic['NomTecnic'].'</td>';
      echo '<td><a href="tecnic.php?tecnic='.$row_rstTecnic['NumTecnic'].'" title="View details for '.$row_rstTecnic['NomTecnic'].'">see</a></td></tr>';
  }
  else {
      echo '<td>&nbsp;</td></tr>';
  }
}
echo '</table>';
?>[/code]

[Chetan]

its same