-
June 17th, 2012, 08:40 AM
#1
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>";
Last edited by Brad Jones; June 26th, 2012 at 12:20 PM.
Reason: Changed code tags to php tags
New to PHP and MySql. Started looking at scripts about a week ago. So far have very little understanding of it. So please be easy with me if I ask a stupid question.
www.ethans-space.com
-
June 17th, 2012, 10:04 PM
#2
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>
Last edited by Brad Jones; June 26th, 2012 at 12:20 PM.
If the post was helpful...Rate it! Remember to use [code] or [php] tags.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|