Update

eagleeye -> du gav mig denne besked, men den opdatere ikka databasen...

Hej.

Den SQL skal se sådan her ud:
SQL = "UPDATE users SET user_email = '"& SQLReplace(Request.Form("email")) &"', user_password = '"& SQLReplace(Request.Form("password")) &"' WHERE ....."

Jeg har lavet ..... fordi du skal hvade en WHERE id = brugerID ellers opdater du hele din database. Så du skal havde en kolonne som du kan identificer en unikbruger enten ved username eller id (autonummer-felt).

Hvis du bruger ID så skal du lave en hidden felt i din form som så bliver først med, her antager jeg har ID er lig med session("mail_login")
<input type="hidden" name="id" value="<%=session("mail_login")%>">

Det her felt som du kan rette email i mangler et navn (name):
<input type="text" value="<% = mail(session("mail_login")) %>" size="30">
Ret til denne:
"><input type="text" name="email" value="<% = mail(session("mail_login")) %>" size="30">


Så kommer din SQL til at se sådan her ud:
SQL = "UPDATE users SET user_email = '"& SQLReplace(Request.Form("email")) &"', user_password = '"& SQLReplace(Request.Form("password")) &"' WHERE id = " & Request.Form("id")

Hvilken fejl får du?

den bare reloader siden, men den har ikke opdateret...

Hvordan ser hele din kode ud?

<%@ Language=VBScript %>
<!--#include file="code_lib.asp"-->
<% SessionTjek() %>
<%
If Request.ServerVariables("REQUEST_METHOD") = "POST" Then
For each item in Request.Form
  If Request.Form(item) = "" Then
  fejl = True
End if
NEXT
If Not fejl = True Then
SQL = "UPDATE users SET user_email = '"& SQLReplace(Request.Form("email")) &"', user_password = '"& SQLReplace(Request.Form("password")) &"' WHERE id = " & Request.Form("id")
  Conn.ExeCute(SQL)
  Response.Redirect("bruger.asp")
Else
End If
End If
%>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta http-equiv="Content-Language" content="da">
<TITLE>Sport / Idræt - Medier</TITLE>
</HEAD>
<BODY BGCOLOR=#FFFFFF>
<TABLE WIDTH=741 BORDER=0 CELLPADDING=0 CELLSPACING=0 align="center" valign="middle">
<TR>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=25 HEIGHT=1></TD>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=1 HEIGHT=1></TD>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=145 HEIGHT=1></TD>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=25 HEIGHT=1></TD>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=519 HEIGHT=1></TD>
<TD>
<IMG SRC="images2/spacer.gif" WIDTH=26 HEIGHT=1></TD>
</TR>
<TR>
<TD COLSPAN=6><IMG SRC="images2/over_01.gif" WIDTH=741 HEIGHT=21></TD>
</TR>
<TR>
<TD ROWSPAN=14><IMG SRC="images2/over_02.gif" WIDTH=25 HEIGHT=484></TD>
<TD ROWSPAN=2><IMG SRC="images2/over_03.gif" WIDTH=1 HEIGHT=70></TD>
<TD COLSPAN=3><IMG SRC="images2/over_04.gif" WIDTH=689 HEIGHT=69></TD>
<TD ROWSPAN=14><IMG SRC="images2/over_05.gif" WIDTH=26 HEIGHT=484></TD>
</TR>
<TR>
<TD COLSPAN=3><IMG SRC="images2/over_06.gif" WIDTH=689 HEIGHT=1></TD>
</TR>
<TR>
<TD COLSPAN=4><IMG SRC="images2/over_07.gif" WIDTH=690 HEIGHT=19></TD>
</TR>
<TR>
<TD COLSPAN=2><a href="mails.asp"><IMG SRC="images2/over_08.gif" WIDTH=146 HEIGHT=31 border="0"></a></TD>
<TD ROWSPAN=11><IMG SRC="images2/over_09.gif" WIDTH=25 HEIGHT=395></TD>
<TD ROWSPAN=11 background="images2/over_10.gif" valign="top">
<form action="bruger.asp" METHOD="POST">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center" colspan="2"><input type="hidden" name="id" value="<%session("mail_login")%>"</td>
</tr>
<tr>
<td width="50%" align="center">Navn</td>
<td width="50%"><% = username(session("mail_login")) %></td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">&nbsp;</td>
</tr>
<tr>
<td width="50%" align="center">Status</td>
<td width="50%"><% = status(session("mail_login")) %></td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">&nbsp;</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">&nbsp;</td>
</tr>
<tr>
<td width="50%" align="center">Password</td>
<td width="50%"><input type="password" name="password" value="<% = password(session("mail_login")) %>" size="30"></td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">&nbsp;</td>
</tr>
<tr>
<td width="50%" align="center">E-mail*</td>
<td width="50%"><input type="text" name="email" value="<% = mail(session("mail_login")) %>" size="30"></td>
</tr>
<tr>
<td width="100%" align="center" colspan="2">&nbsp;</td>
</tr>
<tr>
<td width="100%" align="center" colspan="2"><input type="submit" value="Update"></td>
</tr>
<tr>
<td width="100%" colspan="2">
&nbsp;* E-mailen er den e-mail som du bruger mest udenfor systemet, og som du vil være nemmest at blive kontaktet på.
<br>
<br>
Hvis du ikke vil oplyse din mail, så skal du i stedet skrive N/A.
</td>
</tr>
</table>
</form>
</TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC="images2/over_11.gif" WIDTH=146 HEIGHT=19></TD>
</TR>
<TR>
<TD COLSPAN=2><a href="member.asp"><IMG SRC="images2/over_12.gif" WIDTH=146 HEIGHT=31 border="0"></a></TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC="images2/over_13.gif" WIDTH=146 HEIGHT=20></TD>
</TR>
<TR>
<TD COLSPAN=2><a href="kampkort.asp"><IMG SRC="images2/over_14.gif" WIDTH=146 HEIGHT=30 border="0"></a></TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC="images2/over_15.gif" WIDTH=146 HEIGHT=19></TD>
</TR>
<TR>
<TD COLSPAN=2><a href="bruger.asp"><IMG SRC="images2/over_16.gif" WIDTH=146 HEIGHT=30 border="0"></a></TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC="images2/over_17.gif" WIDTH=146 HEIGHT=71></TD>
</TR>
<TR>
<TD COLSPAN=2><a href="logout.asp"><IMG SRC="images2/over_18.gif" WIDTH=146 HEIGHT=30 border="0"></a></TD>
</TR>
<TR>
<TD COLSPAN=2><IMG SRC="images2/over_19.gif" WIDTH=146 HEIGHT=19></TD>
</TR>
<TR>
<TD COLSPAN=2 background="images2/over_20.gif" width="144" height="93" valign="top"></TD>
</TR>
<TR>
<TD COLSPAN=6><IMG SRC="images2/over_21.gif" WIDTH=741 HEIGHT=25></TD>
</TR>
<TR>
<TD COLSPAN=6><IMG SRC="images2/over_22.gif" WIDTH=741 HEIGHT=1></TD>
</TR>
</TABLE>
</BODY>
</HTML>

glem det.... laver en ny med flere point....