% sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=ptmxhosting_; UID=member;PASSWORD=pass1234; OPTION=3" Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open(sConnection) If Err <> 0 Then Response.Write "Database Open Error" Else Dim sqlstmt, id SqlStmt = "SELECT * FROM press order by Id desc" Set RS2 = objConn.Execute(SqlStmt) End If %>
| <% while not RS2.EOF %> | |
><%=RS2("headline")%> |
<% =RS2("reldate")%> |