PHP and SQL into cells and rows

[davidjmorin]

Hey everyone. I have some code that shows results in a table

Right now it will show 3 cells per row. The issue is that the first row shows 2 then creates a new row with the expected behavior fine after that. How can i get the first row to show 3 cells

   if(++$cnt == 0) {
        echo '<tr>';
    } elseif($cnt % 3 == 0) {
        echo '</tr><tr>';
    }
 
      echo "<td bgcolor='#009933'><a href='" . $row['local_link'] . ".m4v' name='video'>" . $row['local_link'] . "</a></td>";
  echo "<td><video width='320' height='240' controls='controls'>
  <source src='" . $row['local_link'] . ".m4v" . "' type='video/mp4' />
  Your browser does not support the video tag.
</video></td>";


  }
  }
echo "</table>"; 

[PeejAvery]

It's all about placement! Also, do your best to use PHP's echo as little as possible.

<?php $row['local_link'] = 'testing'; ?>
<table border="1">
  <tr>
<?php
$cols = 3;
for ($i = 0; $i < 15; $i++) {
?>
<td bgcolor="#009933"><a href="<?php echo $row['local_link']; ?>.m4v" name="video"><?php echo $row['local_link']; ?></a></td>
<td>
  <video width="320" height="240" controls="controls">
    <source src="<?php echo $row['local_link']; ?>.m4v" type="video/mp4" />
    Your browser does not support the video tag.
  </video>
</td>
<?php
  if (($i + 1) % $cols == 0) { ?></tr><tr><?php }
}
?>
  </tr>
</table>