[Resolved] Display data (from mysql) in 4s

[ofSHIZ]

Hey everyone, here is what I am trying to do. I have a database with some data in it, and I want to display it in 4s. An HTML Table would be setup like this
<table>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
Im having a hard time doing this with PHP, because it is only giving me one big long row. Here is my coding:

<table width="680" border="1" cellspacing="3" cellpadding="3">
<tr>
<?php
$db = mysql_connect("localhost","root") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!"); 
mysql_select_db("micko", $db);
$sql = "SELECT * FROM $act ORDER BY id DESC"; 
$result =  mysql_query($sql) 
    OR die(mysql_error()); 

while($row = mysql_fetch_array($result))
      {
	$id = $row['id'];
	$author = $row['username'];
	$url = $row['img_url'];
	$date = $row['date'];
	$caption = $row['caption'];
	echo "<td>
<font face='Arial, Helvetica, sans-serif' size='1.5'>$caption<br><a href='viewer.php?use=$url'><img src='$url' alt='$caption' width='160' height='120'></a><br>Submited by <b>$author</b>.</td>
";}

?></td></tr>
</table>

[devinemke]

use [man]array_chunk[/man]. here's a basic example:

<?php
$db = mysql_connect('localhost', 'root', 'passowrd') or die(mysql_error());
mysql_select_db('micko', $db) or die(mysql_error());
$sql = "SELECT * FROM $act ORDER BY id DESC";
$result =  mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[] = $row;}
$chunks = array_chunk($array, 4);

echo '<table border="1">';
foreach ($chunks as $value)
{
	echo '<tr>';
	foreach ($value as $sub_value)
	{
		echo '<td>' . $sub_value['username'] . '</td>';
	}
	echo '</tr>';
}
echo '</table>';
?>

[paulnaj]

Hi all,

Here's an alternative using a counter variable and testing it modulo 4.

<table width="680" border="1" cellspacing="3" cellpadding="3"> 
	<tr> 
<?php 
$db = mysql_connect("localhost", "root") or mysql_die ("Unable to Connect to Mysql.. please contact Brandon about this!");  

mysql_select_db("micko", $db); 
$sql = 'SELECT * FROM '.$act.' ORDER BY id DESC';  

$result =  mysql_query($sql) OR die(mysql_error());

$counter = 0;
while($row = mysql_fetch_array($result)){ 
	$id = $row['id']; 
	$author = $row['username']; 
	$url = $row['img_url']; 
	$date = $row['date']; 
	$caption = $row['caption']; 
	echo '
		<td><font face="Arial, Helvetica, sans-serif" size="1.5">'.$caption.'
			<br><a href="viewer.php?use='.$url.'"><img src="'.$url.'" alt="'.$caption.'" width="160" height="120"></a>
			<br>Submited by <b>'.$author.'</b>.
		</td>';

if((++$counter % 4) == 0){
	echo '
</tr>
<tr>';
}
} 
?>
	</tr> 
</table> 

Paul. 🙂

[ofSHIZ]

Ok, Thanks for the replys. Using Pual's method. it works now.