Thread: while loop
View Single Post
  #1 (permalink)  
Old October 5th, 2005, 03:32 AM
mikedeepak mikedeepak is offline
Authorized User
Join Date: May 2004
Location: chennai, tamil nad, India.
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
Default while loop

i have table name loan with 2 columns
while i retrieved and using recordset i got the result like the below list
While not rs.eof
response.write rs(0) & "- " rs(1)
Result is
Personal Loan – PLType1
Personal Loan – PLType 2
Personal Loan – PLType 3
Personal Loan – PLType 4
Home Loan - HLType1
Home Loan - HLType2

now i need to display the result as

Personal Loan(PLType1/PLType2/PLType3/PLType4)
Home Loan(HLType1/HLType2)

Could any one help to make the result