admin
05-28-2003, 11:47 PM
You can use a hyperlink to pull data from your database...
Create your links like this:
<a href="getdata.asp?city=Boston">Boston</a>
<a href="getdata.asp?city=LA">L.A</a>
Now in getdata.asp create your connection to the database and query it:
SQL="SELECT * FROM yourdatabase WHERE city=" & Request.QueryString("city")
Set RS=dataConn.Execute(SQL)
%>
Show the results in getdata.asp.
<%=Request("city")%>
Create your links like this:
<a href="getdata.asp?city=Boston">Boston</a>
<a href="getdata.asp?city=LA">L.A</a>
Now in getdata.asp create your connection to the database and query it:
SQL="SELECT * FROM yourdatabase WHERE city=" & Request.QueryString("city")
Set RS=dataConn.Execute(SQL)
%>
Show the results in getdata.asp.
<%=Request("city")%>