[Resolved] Formatting results

[Muses]

On my genre list there are 10 option, I would like these to appear in 2 rows, 5 columns each but I am not sure how to go about it. Any help or guide in the right direction would be appreciated.

<table align=center width=100% border="1" bordercolor="#8080C0">
<tr><td colspan=10 align=center background="img/nav_bg.jpg">Genre List</td></tr>
<tr>

require_once ('../mysql_connect.php');

$result = mysql_query("SELECT DISTINCT authgenre.* FROM authgenre WHERE 1 ORDER BY authgenre_title ASC");
echo mysql_error();  

if (mysql_num_rows($result)) 
while($row = mysql_fetch_array($result)) { 

echo"<td align=center class=title>" . $row['authgenre_title'] . "</td>";


}

</tr>
</table>

[trex005]

$cols = 2; // how many cols you want
echo '<table align=center width=100% border="1" bordercolor="#8080C0">
<tr><td colspan=10 align=center background="img/nav_bg.jpg">Genre List</td>';
require_once ('../mysql_connect.php');
$cols = 2; // how many cols you want
$result = mysql_query("SELECT DISTINCT authgenre.* FROM authgenre WHERE 1 ORDER BY authgenre_title ASC");
echo mysql_error();  

if (mysql_num_rows($result)) 
for($i=1;$row = mysql_fetch_array($result);$i++)
{
	if($i==1)
	{
		echo "<TR>";
	}
	echo"<td align=center class=title>" . $row['authgenre_title'] . "</td>";
	if($i==$cols)
	{
		echo "</TR>";
		$i=0;
	}
}
if($i!=1)
{
	echo "</TR>";
}
echo "</table>";

let me know if this works for you

[Muses]

I just had to change the how many columns I wanted to 5 and it worked perfectly.

Thank you.

[trex005]

whoops... I ment to put a 5 there 😉 and whoops on the double defining the VAR