degsy
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by degsy
-
-
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>
Have a small problem...
in PHP
Posted
after the login use a redirect to redirect the user to a profile or index page.