Problem with repeating heading row inside a while loop

maxwell_

Looping through database results (rows) using a while loop, my main heading table row
is not inside the loop so displays once at the top of the output. I also have a third table row
containing subheadings, which because it is inside the loop repeats for every row in the output.

Is it possible to display the sub-headings table row only on the loop's first iteration and then
bypass it thereafter (perhaps using continue or break)?

$sql = "select * from uploads where cat_name = 'Leaflet'";
$result = $connection->query($sql) or die(mysqli_error($connection));
$numRows = $result->num_rows;

<table width="100%" cellspacing="0" cellpadding="0" class="text-decor" align="center">
  <tr>
    <th colspan="4" class="thead">Leaflets</th>
    </tr>
  <tr align="center" class="tbrow">
     <td width="64">Type</td>
    <td width="450">Title</td>
    <td width="100">Size</td>
    <td width="150"> Date</td>
    </tr>


if ($numRows == 0) {  

?>
<br /><br />
<font color="red"><p>No downloads found</p></font>

<?php

} else { 
 while($row = $result->fetch_assoc()) { 
 $bytes = $row['size'];
 $date = $row['upload_date'];
 $document_name = $row['document_name'];
 $document_type = $row['document_type'];
 $description = $row['description'];
?>	
  <tr align="left">
    <td>

 <td align="center"><?php echo $document_name; ?> 

</td>
<td align="center">
<?php echo $newbytes; ?>
</td>
<td align="center">
<?php echo $date; ?></td>
  </tr><tr><td colspan="4"><div class="desc_div">Description</div></td></tr>     This row contains a sub-heading
     <tr><td colspan="4" class="pad"><?php echo $description; ?></td></tr>
       <tr><td colspan="4">&nbsp;</td></tr>
   <?php 
   }  

?>

 </table>

cluelessPHP

How about something like this?

<?php
$sql = "select * from uploads where cat_name = 'Leaflet'"; 
$result = $connection->query($sql) or die(mysqli_error($connection)); 
$numRows = $result->num_rows; 

?>
<table width="100%" cellspacing="0" cellpadding="0" class="text-decor" align="center"> 
  <tr> 
    <th colspan="4" class="thead">Leaflets</th> 
    </tr> 
  <tr align="center" class="tbrow"> 
     <td width="64">Type</td> 
    <td width="450">Title</td> 
    <td width="100">Size</td> 
    <td width="150"> Date</td> 
    </tr> 

<?php
if ($numRows == 0) {   

?> 
<br /><br /> 
<font color="red"><p>No downloads found</p></font> 

<?php 

} else {  

$row = $result->fetchAll(PDO::FETCH_ASSOC); 

foreach ($row as $rows):
 $bytes = $rows['size']; 
 $date = $rows['upload_date']; 
 $document_name = $rows['document_name']; 
 $document_type = $rows['document_type']; 
 $description = $rows['description']; 
?>     

  <tr align="left"> 
    <td> 

 <td align="center"><?php echo $rows['document_name']; ?>  

</td> 
<td align="center"> 
<?php echo $newbytes; ?> 
</td> 
<td align="center"> 
<?php echo $date; ?></td> 
  </tr><tr><td colspan="4"><div class="desc_div">Description</div></td></tr>     This row contains a sub-heading 
     <tr><td colspan="4" class="pad"><?php echo $description; ?></td></tr> 
       <tr><td colspan="4">&nbsp;</td></tr> 
   <?php  

	endforeach;
?> 

 </table>

maxwell_

Hi, using the suggested code has the same output as the code I posted.

The table row

</tr><tr><td colspan="4"><div class="desc_div">Description</div></td></tr>

still repeats each time through the loop

cluelessPHP

<tr><td colspan="4"><div class="desc_div">Description</div></td></tr>

<tr><td colspan="4"><div class="desc_div"><?php echo $description; ?></div></td></tr>

Oh not wait sorry,

<tr><td colspan="4"><div class="desc_div"><?php echo $rows['description']; ?></div></td></tr>

NogDog

Maybe...

$lastDescription = null;

while($row = $result->fetch_assoc()) {
    // some stuff, then
    if($description != $lastDescription) {
        $lastDescription = $description;
        // echo the sub-header row using $description here
    }
}

maxwell_

Please see full script bellow with added code enclosed in ###

<?php
$sql = "select * from newsletters";
$result = $connection->query($sql) or die(mysqli_error($connection));
$numRows = $result->num_rows;
$noRows = '<p class="red_color">No Newsletters available</p>';

?>
<table width="100%" cellspacing="0" cellpadding="0" class="text-decor" align="center">
  <tr>
    <th colspan="4" class="thead">Newsletters</th>
    </tr>
  <tr align="center" class="tbrow">
     <td width="64">Type</td>
    <td width="450">Title</td>
    <td width="100">Issue</td>
    <td width="150">Size</td>
    </tr>

<?php
if ($numRows == 0) {  

?>
 <tr><td colspan="4"><?php echo $noRows; ?></td></tr> 
<?php

} else { 

############
$lastDescription = null;
############

while($row = $result->fetch_assoc()) {
    // some stuff, then
	$bytes = $row['size'];
 $date = $row['upload_date'];
 $document_name = $row['document_name'];
 $document_type = $row['document_type'];
 $description = $row['description'];

#######################
if($description != $lastDescription) {
        $lastDescription = $description;
        $rowVar = '<tr><td colspan="4"><div class="desc_div">Descriprion</div></td></tr>';
    }
#######################


 $newbytes = formatSizeUnits($bytes);

?>	
  <tr align="left">
    <td>
    <?php 

$query = "SELECT * FROM document_type WHERE file_type = '{$document_type}' ";
						$select_type = mysqli_query($connection, $query);

				if (mysqli_num_rows($select_type) > 0) {

						while($row = mysqli_fetch_assoc($select_type)){

						$type_id = $row['type_id'];
						$file_type = $row['file_type'];	

						if($file_type == 'PDF') 
						{  
							$file_type = 'Adobe_Acrobat.png';                 
						} 
						if($file_type == 'JPG') 
						{  
							$file_type = 'jpg.png';                 
						}
						elseif($file_type == 'WORD') 
						{  
							$file_type = 'word.png';                 
						} 

					?>	
                    <img class="imgBottom" src="images/<?php echo $file_type; ?>"> 	

					<?php							

						 }  

						} 

						?>
                        <td align="center"><?php echo $document_name; ?> 

<img src="images/download.png" name="Image9" width="32" height="32" border="0" align="absmiddle">   

    </td>
    <td align="center">
	<?php echo $date; ?>
    </td>
    <td align="center">
	<?php echo $newbytes; ?></td>
  </tr>
    #############
<?php echo $rowVar; ?>
#############

<tr><td colspan="4" class="pad"><?php echo $description; ?></td></tr>
   <tr><td colspan="4">&nbsp;</td></tr>
   <?php }  

?>
 </table>
<?php 
} 
?>

sneakyimp

I would suggest trying something simpler and more basic -- without all the HTML markup -- to make sure you are defining the PHP variables you want before you try and output all the markup. It's considered bad form to be opening and closing PHP tags and mixing your markup in with queries, etc. Try and run your queries first and generate your data arrays and THEN start spouting HTML.