When doing member information to modify, the default item positioning of the drop-down menu is implemented.

Author: lshdic

http://blog.9cbs.net/lshdic/

<%

Set link1 = server.createObject ("AdoDb.Connection") 'The following is the database connection, of course you can use Access

Lin1.open "provider = SQLOLEDB; user ID = username; password =; initial catalog = database name; Data Source = SQLServer server name

SET RS = Server.createObject ("AdoDb.Recordset")

RS.Open "SELECT * FROM member table Where nickname = '" & session ("who") & "'", link1, 1, 2

%>