Menu
Community /Pin to ProfileBookmark
@NogDogNov 04.2006 — #I usually do something like:
display results in column
Hi,
Is there any better way, to display results in column, let says, 3 columns in a rows.
[code=php]
<html>
<table border=”1″ CELLSPACING=”0″ CELLPADDING=”10″ align=”center”>
<?php
$db = @mysql_connect(“localhost”, “root”, “”);
if( ! ($db = @mysql_connect(“localhost”, “root”, “”)) ) {
} else {
mysql_select_db(“database”,$db) or die(“Select DB Error: “.mysql_error());
}
//set 3 to 4 of you want 4 columns. Set it to 5 if you want 5, etc
$numcols = 3; // how many columns to display
$numcolsprinted = 0; // no of columns so far
// get the results to be displayed
$query = “SELECT * FROM cc”;
$mysql_result = mysql_query($query, $db);
// get each row
while($myrow = mysql_fetch_row($mysql_result))
{
//get data – eg, reading fields 0 and 1
$tn = $myrow[0];
$in= $myrow[1];
if ($numcolsprinted == $numcols) {
print “</tr>n<tr>n”;
$numcolsprinted = 0;
}
// output row from database
echo “<td>$in $tn</td>n”;
// bump up row counter
$numcolsprinted++;
} // end while loop
$colstobalance = $numcols – $numcolsprinted;
for ($i=1; $i<=$colstobalance; $i++) {
}
print “<TD> </TD>n”;
?>
</table>
</html>
Sign in
to post a comment6 Comments(s) ↴
0
@NogDogNov 04.2006 — #I usually do something like:[code=php]
$result = mysql_query($sql) or die("$sql - ".mysql_error());
echo "<table>n<tr>";
$count = 0;
$numCols = 3;
while($row = mysql_fetch_assoc($result))
{
if($count != 0 and $count % $numCols == 0)
{
echo "</tr>n<tr>";
}
echo "<td>{$row['name']}</td>";
$count++;
}
echo "</tr>n</table>n";
?>
[/code]