Is there a way to determine if a user clicks on a link, and if so, update a file / database?
Also, this is more geared to ASP: If you already have an SQL query executed, how can you do another?
Example:
PHP Code:
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("directory\to\database\file.mdb")
MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT * FROM files"
Set RS = MyConn.Execute(SQL_query)
%>
How would I be able to run another SQL query (like UPDATE)?