display in two seprate table

[sandeeps srivastava]

hi ,
i have a problem , i fetch 24 columns from database i want to split in two separate table 12 field in each table, i write code here please help me

  result = stmt.executeQuery("SELECT * FROM indian_languages ");
while(result.next())
 {%>  

 
 <table border="1" bgcolor="white" width="100%" height="20%" cellspacing="0" cellpadding="0" >  
       
<tr>  
   
 <td ><%= result.getString(1) %> </td>  

 <td > <%= result.getString(2) %> </td>  

 <td > <%= result.getString(3) %></td>  

    <td > <%= result.getString(4) %> </td>  
<td > <%= result.getString(5) %> </td>  
 
<td >  <%= result.getString(6) %></td>   

 <td ><%= result.getString(7) %> </td>  
 <td  > <%= result.getString(8) %></td>  

     <td > <%= result.getString(9) %></td>  
     <td > <%= result.getString(10) %></td>  
     <td > <%= result.getString(11) %> </td>
     <td > <%= result.getString(12) %> </td>      
             <td  > <%= result.getString(13) %> </td>
                     <td  > <%= result.getString(14) %> </td>  
             <td ><%= result.getString(15) %> </td>   
                     <td  > <%= result.getString(16) %> </td> 
     <td > <%= result.getString(17) %> </td>  
             <td > <%= result.getString(18) %> </td>  
             <td  > <%= result.getString(19) %> </td>  
             <td  ><%= result.getString(20) %> </td>  
     <td ><%= result.getString(21) %> </td>  

                    <td > <%= result.getString(22) %> </td>  
       <td > <%= result.getString(23) %> </td>  
  
  <td ><%= result.getString(24) %></td>  
 
<!--</div >--> </tr> </table> 

 <%}

 out.println("<br>");
  out.println("<br>");
 out.println("</body></html>"); 
}    

[Paul Michael]

You should probably close the table using after the 12th field

</tr>
</table>

and start a new table before the 13th field

<table>
<tr>

If you want more complicated sorting/arrangement of your results, you might probably need to temporarily store the results you got from the result set into a Collection object before displaying the tables.