用Php隐藏列

Question

我有一个关于隐藏空列的问题。

如何隐藏< th>姓名</th>当我有空列的头列？

在接下来的日子里我工作到SWITH到mysqli的所有查询:-)

QUERY 
$query = " SELECT * FROM users "; 
$result = mysql_query($query) or die(mysql_error()); 
$num = mysql_num_rows($result); 

TABLE 
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example"> 

<thead> 
    <tr> 
     <th>NAME</th> 
     <th>SURNAME</th> 
    </tr> 
</thead> 

<tbody> 
    <?php 
     $i=0; 
     while ($i < $num) { 
      $id = mysql_result($result,$i,"id"); 
      $name = mysql_result($result,$i,"name"); 
      $surname = mysql_result($result,$i,"surname"); 
    ?> 

    <tr> 
     <td><?php echo $name; ?></td> 
     <td><?php echo $surname; ?></td> 
    </tr> 

    <?php 
     $i++; 
     } 
    ?> 
</tbody> 

</table> 

Answer 1

要隐藏列，您需要同时前检查。

$array_surname = array(); 
    while($res_head_surname = mysql_fetch_array($result)) { 
     $array_surname[] = $res_head_surname; 
    } 

在此之后，插入条件，只要你喜欢，并加入到头表：

<?php if ($show_surname == 1) {?><th>SURNAME</th><?php } ?> 

Answer 2

试试这个！只要把一个如果检查姓氏如果存在或不。并在回声中包含标签。

QUERY 
$query = " SELECT * FROM users "; 
$result = mysql_query($query) or die(mysql_error()); 
$num = mysql_num_rows($result); 
TABLE 
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example"> 

<thead> 
    <tr> 
     <th>NAME</th> 
     <th>SURNAME</th> 
    </tr> 
</thead> 

<tbody> 
    <?php 
     $i=0; 
     while ($i < $num) { 
      $id = mysql_result($result,$i,"id"); 
      $name = mysql_result($result,$i,"name"); 
      $surname = mysql_result($result,$i,"surname"); 
    ?> 

    <tr> 

 <?php echo "<td>".$name."</td>"; ?> 
     <td><?php if($surname){echo "<th>".$surname."</th>";} ?></td> 

</tr> 

    <?php 
     $i++; 
     } 
    ?> 
</tbody> 

</table>