Next link :(
Hey there peopleI made a HUGE big mistake with my last database and after recieving great help from some of the experts here, I realised I had created a database that is NOT user friendly ;(
Sooooo here I go again
I am try to insert a next link, and for the results to be displayed in 2 columes
I tried before but still stuffed it up,
so any ideas from anyone would be welcome
heres the script
<body>
<link rel=\"stylesheet\" style=\"text/css\" href=\"../styles.css\">
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"popup.mdb\")
strSQL = \"SELECT * FROM abc WHERE alpha=\'\" & request(\"alpha\") & \"\';\"
Conn.Execute (strSQL)
Set rs = conn.Execute(strSQL)
if not (rs.BOF Or rs.EOF) Then
%>
<table class=\"border\" width=\"300\" align=\"center\" valign=\"top\" cellpadding=\"5\" cellspacing=\"0\" border=\"0\">
<tr>
<td class=\"one\"><table>
<% Do While Not rs.EOF %>
<tr>
<td><a href=java script:reqWin(\'popup.asp?id=<%= RS(\"ID\")%>\')><%=rs(\"word\")%></a></td>
</tr>
<%
RS.MoveNext
Loop
%>
</table>
</td>
</tr>
</table>
<%
conn.Close
Set conn = nothing
%>
<% else %>
<%
response.redirect (\"default.asp\")
%>
</body>
you can also check this link to see what I mean
http://www.guzzie.dk/dictonary_popup/default.asp
