|
hey every to everybody i want the result in such way that frist four feilds in while loop and last one should print only one time ,how to do
<%
st11=con.createStatement();
q11="select sr.subid,c.subject,c.units,z.cgpa from studentregdata sr, courses c, checkcgpa z where sr.sidno like'"+id+"' and sr.subid= c.subid and z.sidno=sr.sidno order by sr.subid";
System.out.println(q11);
rs11=st11.executeQuery(q11);
while(rs11.next())
{
%>
<tr>
<td width="13%"><font face="Arial" style="font-size: 8pt; font-weight: 300"><center><%= rs11.getString(1)%></center></font></td>
<td width="33%"><font face="Arial" style="font-size: 8pt; font-weight: 300"><%= rs11.getString(2)%></font></td>
<td width="13%"><font face="Arial" style="font-size: 8pt; font-weight: 300"><center><%= rs11.getString(3)%></center></font></td>
<td width="13%"><font face="Arial" style="font-size: 8pt; font-weight: 300"><center><%= rs11.getString(4)%></center></font></td>
<td width="13%"><font face="Arial" style="font-size: 8pt; font-weight: 300"><center>5.49</center></font></td></tr>
<%
}
rs11.close();
st11.close();
%>
|
Linear Mode
