Help with displaying mysql query in html columns

[phenom18]

hello ! i'm fairly new to php and sql so would greatly appreciate if anyone could help me with this.

what i want to do is to get different users to enter a single field say their name through a form and then display it in the following format

 

name 1  name 2    name 3      name 4    name 5

name 6  name 7    name 8      name 9    name 10

name 11  ............so on

 

no. of rows is no limit.

 

here's the code but its not working

 

while ( $row = mysql_fetch_assoc($result) )

{

echo("<tr>"); 

  $ctr=1;

      if($ctr<6)

      {

          echo("<td>"); 

          echo($row["name"]); 

          echo("</td>");

    $ctr++;

     

} 

   

    echo("</tr>");  // end the row

}

[rajivgonsalves]

your code should be something like the following

 

$ctr=1;
echo "<tr>";   
while ( $row = mysql_fetch_assoc($result) )
{
    if (($ctr%6)==0) {echo "</tr><tr>";}
echo "<td>";   
    echo $row["name"]; 
   echo "</td>";
     $ctr++;
    
}
echo("</tr>");  // end the row

 

hope its helpful

 

 

 

[phenom18]

thankkk u very muchh....that worked just fine.....!!!!