how to display more than one result from the db..

[City Guy]

if (rs != null) {
if (rs.next()) {
xxx = rs.getString("");
xxx = rs.getString("");
xxx = rs.getString("");
xxx = rs.getString("");
xxx = rs.getString("");
this will only disply one record ...

[Mahesh Rana]

<code>
if(rs != null)
{
while(rs.next())
{
x = rs.getString("X");
}
}
</code>

[namita pa]

ya its better to do it in the while loop as it checks all the records in the resultset
------------------