degsy

after the login use a redirect to redirect the user to a profile or index page.

I would recommend http://34sp.com as a budget host.

Here is a basic tutorial http://www.kamath.com/tutorials/tut003_auth.asp

If is a table cell value in HTML then you would probably have to extract it's value using javascript and set it as the value of a hidden form field.When the form is submitted you can take the data from the hidden field.

I usually use something similar to this

conn_name = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\path\database.mdb")

Then to connect in your script

Set rs = Server.CreateObject("ADODB.Recordset")rs.ActiveConnection = conn_name

e.g.

<%Set rs = Server.CreateObject("ADODB.Recordset")rs.ActiveConnection = conn_namers.Source = "SELECT TOP 10 user_id, username  FROM [USER]  ORDER BY user_id DESC"rs.CursorType = 0rs.CursorLocation = 2rs.LockType = 1rs.Open()%>

Usually you would go with the SQL that Skemcin has posted and use a loop to iterate through the recordse.g. if you has two fields called user_id and username in a table called USER

Set rs = Server.CreateObject("ADODB.recordset")dataSQL = "SELECT TOP 10 user_id, username  FROM [USER]  ORDER BY user_id DESC"rs.Open dataSQL, conn

<table border="1" cellpadding="0" cellspacing="2">  <tr>    <td>user_id</td>    <td>username</td>  </tr>  <% While NOT rs.EOF%>  <tr>    <td><%=rs("user_id")%></td>    <td><%=rs("username")%></td>  </tr>  <%   rs.MoveNext()Wend%></table>