Er der nogle der kan hjælpe !
Er der nogle der kan hjælpe !Jeg har et problem med dette script ! Siden her skal vise enten 1 af valgte oplysninger eks. rpc eller rps2...
Hvad er der galt med scriptet!!!
-----------------------------------------------------------
<%
dim mode, id
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("database.mdb")
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open strDSN
id = Request("rid")
sp = Request("sp")
myconn.Execute("Update cheats SET hits =hits+1 where id="&id)
%>
<!--#include file="config.asp" -->
<html>
<head>
<title><%=SetTitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body background="images/grid.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/topbar.jpg" width="700" height="88" border="1"></td>
</tr>
</table>
<br>
<!--#include file="inc_menu.htm" -->
<br>
<table width="700" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF">
<tr bordercolor="#FFFFFF">
<td width="503"><div align="left">
<p> </p>
</div></td>
<td width="197"><div align="right"><b><b>Sector.dk har <%=antal%></b> koder</b></div></td>
</tr>
<tr bordercolor="#FFFFFF">
<td colspan="2"> <p align="center"> <strong>
<% strSQL = "SELECT * From cheats where id = " & id
Set rs = myConn.Execute(strSQL)
%>
<font face=tahoma size=2><%=rs("spilnavn")%></font></strong>
<table width="80%" height="24" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="68%"><font face=tahoma><b>Koden</b></font></td>
</tr>
<%
Do Until rs.EOF
%>
<tr>
<td width="68%"> <%
if sp="rpc" then response.write "rpc"
if sp="rps2" then response.write "rps2"
%> <%= rs("r"&sp) %> </td>
</tr>
<%
rs.MoveNext
Loop
%>
<p></p>
</table>
<p></p></td>
</tr>
</table>
<br>
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="19"><div align="center"><font size="1">© Copyright 2003
<script language="JavaScript">
var d=new Date();
yr=d.getFullYear();
if (yr!=2003)
document.write("-"+yr);
</script>
by 123design - Media. All rights reserved. </font></div></td>
</tr>
</table>
</body>
</html>
-----------------------------------------------------------
/Daniel
