mickey

i want to make if the user type a word to search then the system will display all list that have the word in it.how can i do it.what is the coding?

The problem is that you use a variable to display your result. In the while loop you get the value, you assign that to the variable, then get the next, ovewrite the same variable with the new value and so on. So you only display the last value, right?Your solution would be to display the result in the while loop, something like this:Do While Not rsEnc.EOFsGQDEncName = rsEnc.Fields("name")sGHTTemp = sGHTTemp & " <tr>" & vbCrLf & _" <td colspan=2 width=100%_>" & vbCrLf & _" <span class='issue-field-label'>Enclosure Records</span>" & vbCrLf & _" <span class='issue-field-content'>: " & sGQDEncName & "</a>" & vbCrLf & _" </span>" & vbCrLf & _" </td>" & vbCrLf & _" </tr>" & vbCrLf & _"</table>" & vbCrLfrsEnc.movenext loopelseresponse.write "end of file"end iffnCLDestroyObject(rsEnc)Try this and let me know!

i did my coding like this.then as long there is still data in the dbase it will display it.hope it work for you.i'm new too in asp.about 1 and half month.<%while not rs.EOF%>Response.Write("<TD>")Response.Write(rs("courses")& "</TD>")

I would suggest setting up your data so that you have three tables in your database: UserProfiles, Courses, User_Courses (or some other more intuitive name).

UserProfiles:   - UserProfileID   - Username   - Password   - FirstName   - LastName   - etc...Courses:   - CourseID   - Title   - Description   - Credits   - etc...User_Courses:   - UserProfileID   - CourseID

This way you will have one UserProfile record for each user, one Course record for each course, and as many records as you want for the pairing of users and courses. If a particular user (say UserProfileID = 4) signs up for 4 courses (CourseIDs 5, 16, 22, and 31), your User_Courses table would contain:

UserProfileID	CourseID4				   54				   164				   224				   31

I hope this helps.

i can do it now.thanks

i made a form where a user will entered the courses that they want to attend.i wish to make the user can choose multiple courses in one form but only once enter their profile.what i want to ask is how can i make duplicate data in database so each of the courses will be put into differrent line and the profile of the user will duplicate for each line in dbse.i use access as my dbase.i don't know what kind of coding to use to make that.

i want to make when the user want to changed the password,they have to entered old password,new password and confirm password.can anyone help me with the coding?the old password must exactly as the current password.and new and confirm password must be same.help me please