pull data into multi columns with PHP?

urbandog

Hello-

I'd like to display information in a table from my db. I can get the information to go down in rows, but I rather have them display in columns as well.

1 2 3 4
5 6 7 8

1 4
2 5
3 6

thank you for all suggestions.

Marie

YappyDog

Columns is pretty easy. Just put out your normal table td tags and then every so often put out a set of ending and starting tr tags.

something like this (totally untested:

$RowCount = 0;
while loop that fetches data into $row{
$RowCount++;
echo "<td> . $row["name"] . "</td>";
if (fmod($RowCount,5) == 0)
echo "</tr><tr>";
}

urbandog

This is my code, where would I place that...?
(please no laughter 😃 )

<?
$query=mysql_query("select from flipbook order by id desc limit $k, $limit");
$resultcount=mysql_result(mysql_query("select count() as count from flipbook"),0,'count');
while($data=mysql_fetch_array($query)):
echo "<table class=\"subfpo\">
<tr>
<td class=\"subfpo\" align=\"center\">
<div class=\"subtpixs\" align=\"center\"><a href=\"http://www.urbandog.net/$data[url]\" class=\"opacity1\" onmouseover=\"this.className='opacity2'\" onmouseout=\"this.className='opacity1'\"><img src=\"flipbook/$data[image]\" alt=\"photos\" border=\"0\"></a></div>
</td>
<td class=\"subfpocopy\">
<div class=\"tpixs\">

<div class=\"subprojtitle\">$data[title]</div>
<div class=\"subprojdate\">$data[date]</div>
<div class=\"subprojcontent\">$data[description]</div>
<div class=\"subprojtitle\" align=\"right\"><a href=\"$data[url]\">+All Photos</a></div>

</div>
</td>
</tr>";
endwhile;
if($resultcount>0){
if(isset($k) && ($k>0)){
$prev=max($k-$limit,0);
$nav.= "<a href=\"?k=$prev\">«Previous</a> |";
}
$end=(($k+$limit)>$resultcount)?$resultcount🙁$k+$limit);
$nav.="<b>Total :".$resultcount."   Showing: ".($k+1)."-".($end)."</b>";
if (isset($k) && (($k+$limit) < $resultcount)){
$next=$k+$limit;
$nav.= "|<a href=\"?k=$next\">Next»</a>";
}
echo "<tr><td class=\"subprojtitle\"><br><br>$nav</td></tr>";
}
?>

</table>

YappyDog

A rough stab at it..................

<?
$query=mysql_query("select from flipbook order by id desc limit $k, $limit");
$resultcount=mysql_result(mysql_query("select count() as count from flipbook"),0,'count');

$RowCount = 0;
echo "<table class=\"subfpo\"><tr>";

while($data=mysql_fetch_array($query)):
$RowCount++;
echo "<td class=\"subfpo\" align=\"center\">
<div class=\"subtpixs\" align=\"center\"><a href=\"http://www.urbandog.net/$data[url]\" class=\"opacity1\" onmouseover=\"this.className='opacity2'\" onmouseout=\"this.className='opacity1'\"><img src=\"flipbook/$data[image]\" alt=\"photos\" border=\"0\"></a></div>
</td>
<td class=\"subfpocopy\">
<div class=\"tpixs\">

<div class=\"subprojtitle\">$data[title]</div>
<div class=\"subprojdate\">$data[date]</div>
<div class=\"subprojcontent\">$data[description]</div>
<div class=\"subprojtitle\" align=\"right\"><a href=\"$data[url]\">+All Photos</a></div>
</div>
</td>";

if (fmod($RowCount,5) == 0)
echo "</tr><tr>";

endwhile;
echo "</tr>";

if($resultcount>0){
if(isset($k) && ($k>0)){
$prev=max($k-$limit,0);
$nav.= "<a href=\"?k=$prev\">«Previous</a> |";
}
$end=(($k+$limit)>$resultcount)?$resultcount$k+$limit);
$nav.="<b>Total :".$resultcount." Showing: ".($k+1)."-".($end)."</b>";
if (isset($k) && (($k+$limit) < $resultcount)){
$next=$k+$limit;
$nav.= "|<a href=\"?k=$next\">Next»</a>";
}
echo "<tr><td class=\"subprojtitle\"><br><br>$nav</td></tr>";
}
?>

</table>