Opdater ikke godt nok?
Håber der er en der kan hjælpe mig..Jeg har lavet en side hvor jeg kan opdatere en brugers info, den henter fint det som den skal i textfelterne, men når jeg trykker "gem ændringer" gemmer den det ikke.. håber i kan hjælpe, siden ser sådan ud:
<?php
mysql_connect("", "", "");
mysql_select_db("");
if (isset($_POST['usrage'])) {
mysql_query("UPDATE users set usrname='$_POST[usrname]', usrage='$_POST[usrage]', usrinfo='$_POST[usrinfo]', usrclothes='$_POST[usrclothes]', usrid='$_POST[usrid]', usruin='$_POST[usruin]', usrmail='$_POST[usrmail]', usrstatus='$_POST[usrstatus]', usrgender='$_POST[usrgender]', usrweight='$_POST[usrweight]', usrheight='$_POST[usrheight]', usrpass='MD5('$_POST[usrpass]')', usrirlname='$_POST[usrirlname]', usrcredit='$_POST[usrcredit]' WHERE usrid='$_POST[usrid]'");
echo "Info opdateret for: ";
}
$query = mysql_query("SELECT * FROM users WHERE usrid='$_POST[usrid]'");
$row = mysql_fetch_array($query);
?>
<i><?=$row[usrname];?></i>
<form action="rediger.php" method="post">
<input type="hidden" name="usrid" value="<?php echo $_POST['usrid']; ?>">
<br>
<table width="14%" border="0" cellpadding="0" cellspacing="0" height="459">
<tr>
<td>Status: </td>
<td>
<input type="text" name="usrstatus" size="2" maxlength="1" value="<?php echo $row['usrstatus']; ?>" class="box">
</td>
</tr>
<tr>
<td>Køn:</td>
<td>
<input type="text" name="usrgender" size="2" value="<?php echo $row['usrgender']; ?>" class="box" maxlength="1">
</td>
</tr>
<tr>
<td>Alder:</td>
<td>
<input type="text" name="usrage" value="<?php echo $row['usrage']; ?>" class="box" size="3" maxlength="2">
</td>
</tr>
<tr>
<td>Vægt:</td>
<td>
<input type="text" name="usrweight" size="4" maxlength="3" value="<?php echo $row['usrweight']; ?>" class="box">
</td>
</tr>
<tr>
<td>Højde:</td>
<td>
<input type="text" name="usrheight" value="<?php echo $row['usrheight']; ?>" size="4" maxlength="3" class="box">
</td>
</tr>
<tr>
<td> Nick: </td>
<td>
<input type="text" name="usrname" value="<?php echo $row['usrname']; ?>" class="box">
</td>
</tr>
<tr>
<td>Password:</td>
<td>
<input type="text" name="usrpass" value="<?php echo $row['usrpass']; ?>" class="box">
</td>
</tr>
<tr>
<td>Navn:</td>
<td>
<input type="text" name="usrirlname" value="<?php echo $row['usrirlname']; ?>" class="box">
</td>
</tr>
<tr>
<td>€cu:</td>
<td>
<input type="text" name="usrcredit" value="<?php echo $row['usrcredit']; ?>" class="box">
</td>
</tr>
<tr>
<td>Tøj: </td>
<td>
<input type="text" name="usrclothes" value="<?php echo $row['usrclothes']; ?>" class="box">
</td>
</tr>
<tr>
<td>Mail: </td>
<td>
<input type="text" name="usrmail" value="<?php echo $row['usrmail']; ?>" class="box">
</td>
</tr>
<tr>
<td>Icq: </td>
<td>
<input type="text" name="usruin" value="<?php echo $row['usruin']; ?>" class="box">
</td>
</tr>
<tr>
<td>Set profil: </td>
<td>
<input type="text" name="usrcount" value="<?php echo $row['usrcount']; ?>" class="box">
</td>
</tr>
<tr>
<td>Info: </td>
<td rowspan="2">
<textarea name="usrinfo" rows="8" cols="30" class="box"><?php echo $row['usrinfo']; ?></textarea>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<input type="submit" value="Gem Ændringer" class="box">
</form>
