Limitation

[Anon]

Hi everyone,
I have a script that extracts the member names from the database and what I want it to do is display 4 names per row. Can this be done? The script is below:

$sql = "
select id, member
from $table_name
order by id
";

$result = @($sql,$connection) or die("Couldn't execute query.");

$lukeknights = "
<table width=80% cellpadding=2 cellspacing=2 border=0>
<tr>
<td>
";

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

$id = $row['id'];
$member = $row['member'];

$lukeknights .= "
<font size=\"1\" face=\"verdana\" color=\"#800000\"> $member &nbsp;&nbsp;</font>";

}

$lukeknights .= "</td></tr></table>";

?>

Thanks for any help.

:o) Ivan

[Anon]

TRY THIS OUT...

<?php

$sql = "SELECT id, member FROM $table_name ORDER BY id ";

$result = @($sql,$connection) or die("Couldn't execute query.");

$lukeknights = "<TABLE WIDTH=80% CELLPADDING=2 CELLSPACING=2 BORDER=0>
<TR>";

$column=1;
while ($row = mysql_fetch_array($result))
{

if ($column>4)
{
$column = 1;
$lukeknights .= "</TR><TR>";
}

$id = $row['id'];
$member = $row['member'];

$lukeknights .= "<TD>$member</TD>";

$column++;

}

if (substr($lukeknights, -5)!="</TR>") { $lukeknights .= "</TR>"; }

$lukeknights .= "</TABLE>";

?>

[Anon]

Thank You Aaron. It worked perfect!

:o) Ivan