Making columns using MySQL result

[forumnz]

What is the function (so I can look it up) that allows you to have columns of data.

 

Example: I pull 15 rows from DB and want columns with max of 5 rows in a table. After displaying the 5th row it ends the table row and starts a new one for the next 5 and so on...

 

Thanks!

Sam.

[teng84]

no predefined function for this you have to code it manually !

can we see you codes now?

[kts]

hehe code

[forumnz]

echo "<table><tr><td>";
while($row = mysql_fetch_array($sql))
{
$name = $row['name'];
$a = $row['id'];

echo "<a href=browse.php?cat=" . $a . ">" . $name . "</a><br>";
}
echo "</td></tr></table>";
}

[revraz]

http://www.phpfreaks.com/forums/index.php/topic,95426.0.html

[$username]

Try something like this

 

echo "<table>";
while($row = mysql_fetch_array($query)) {

echo "<tr>";
			echo "<td>".$row['']."</td>";
			echo "<td>".$row['']."</td>";
			echo "<td>".$row['']."</td>";
echo "</tr>" ;

}
echo "</table>";

[forumnz]

Hi,

 

Nice try but it doesn't work. I really need help with this - so frustrating. I don't want the code, I just want assistance (I would rather learn it as well).

 

Thanks!

Sam.

[hamza]

WHAT KIND OF RESULT YOU WANT JUST EXPLANIN LITTLE BIT ME I WILL HELP YOU..............

 

[sasa]

try

<?php
echo "<table>";
while($row = mysql_fetch_array($sql)){
$name = $row['name'];
$a = $row['id'];
echo "<tr><td><a href=browse.php?cat=" . $a . ">" . $name . "</a></td>";
for ($i = 1; $i<5; $i++){
	$row = mysql_fetch_array($sql);
	if ($row){
		$name = $row['name'];
		$a = $row['id'];
	}else {
		$name = ' ';
		$a = ' ';
	}
	echo "<td><a href=browse.php?cat=" . $a . ">" . $name . "</a></td>";
}
echo "</tr>";
}
echo '</table>';
?>