Display result from MySQL in columns using CSS
Posted: Tue Apr 07, 2009 9:20 am
Hi all,
I've found some script to display data in 4 columns using css but the problem is output.
I want to output data like
result1 result3 result5 result7
result2 result4 result6 result8
etc...
instead of
result1 result2 result3 result4
result5 result6 result7 result8
The code is:
Thanx.
I've found some script to display data in 4 columns using css but the problem is output.
I want to output data like
result1 result3 result5 result7
result2 result4 result6 result8
etc...
instead of
result1 result2 result3 result4
result5 result6 result7 result8
The code is:
Code: Select all
<?php
$columns = 4;
$sql = "Select id, imgName, imgDescription from imageTable";
//perform the query
$result = mysql_query($sql) or die(mysql_error());
//prepare the css
$column_css = (100/$columns) - 1;
$css = <<<HTML
<style>
.contentHolder {width:85%; margin: 0 auto; text-align:center;}
.innerHolder {width: $column_css; margin-right: 1px; float:left;}
.clear {line-height: 0.5px; visibility: hidden; clear:both;}
}
</style>
HTML;
//prepare the output
$output = <<<HTML
<div id="contentHolder">
HTML;
//iterate the recordset
while ($row = mysql_fetch_assoc($result)){
$output .= <<<HTML
<div class="innerHolder">
<div class="imageHolder">
<img src="images/{$row['imgName']}"
alt="{$row['imgDescription']}"
title="{$row['imgDescription']}" />
</div>
<div class="captionHolder">
{$row['imgDescription']}
</div>
</div>
HTML;
}
//finish the output
$output .= <<<HTML
<div class="clear"> </div><!--- clear the floats for box model issues --->
</div> <!--- finish the contentHolder div --->
HTML;
?>