PHP and SQL into cells and rows
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
PHP Code:
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>";
Re: PHP and SQL into cells and rows
It's all about placement! Also, do your best to use PHP's echo as little as possible.
PHP Code:
<?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>
