Ændre i mysql db. gennem nr. side
Hej jeg er ved at lave så jeg kan ændre i min crew liste gennem min admin del.. men har et lille problem .. jeg skal have siden til at åbne for id 1 !.. her er siden, håber nogle kan hjælpe:<?
if (isset($_POST['alder'])) {
mysql_query("UPDATE drukcrew set navn='$_POST[navn]', alias='$_POST[alias]', laver='$_POST[laver]', alder='$_POST[alder]', kl='$_POST[kl]', girl='$_POST[girl]', icq='$_POST[icq]', komm='$_POST[komm]', andre='$_POST[andre] WHERE id='$_POST[1]'");
echo "Info opdateret for: ";
}
$query = mysql_query("SELECT * FROM drukcrew WHERE id='$_POST[1]'");
$row = mysql_fetch_array($query);
?>
<form action="lars.php" method="post">
<input type="hidden" name="id" value="<?php echo $_POST['id']; ?>">
<br>
<table width="22%" border="0" cellpadding="0" cellspacing="0" height="459" class="tekst_normal">
<tr>
<td width="39%">:Navn</td>
<td width="61%">
<input type="text" name="usrirlname" value="<?php echo $row['navn']; ?>" class="box">
</td>
</tr>
<tr>
<td width="39%"> Alias: </td>
<td width="61%">
<input type="text" name="usrname" value="<?php echo $row['alias']; ?>" class="box">
</td>
</tr>
<tr>
<td width="39%">Laver:</td>
<td width="61%">
<textarea name="usrcount" class="box"><?php echo $row['laver']; ?></textarea>
</td>
</tr>
<tr>
<td width="39%">Alder:</td>
<td width="61%">
<input type="text" name="usrage" value="<?php echo $row['alder']; ?>" class="box" size="3" maxlength="2">
</td>
</tr>
<tr>
<td width="39%">Kl:</td>
<td width="61%">
<input type="text" name="usrclothes" value="<?php echo $row['kl']; ?>" class="box">
</td>
</tr>
<tr>
<td width="39%">Kæreste:</td>
<td width="61%">
<input type="text" name="usrmail" value="<?php echo $row['girl']; ?>" class="box" size="4">
</td>
</tr>
<tr>
<td width="39%">ICQ Nr:</td>
<td width="61%">
<input type="text" name="usruin" value="<?php echo $row['icq']; ?>" class="box">
</td>
</tr>
<tr>
<td width="39%">Kommentar:</td>
<td rowspan="2" width="61%">
<textarea name="usrinfo" rows="8" cols="30" class="box"><?php echo $row['komm']; ?></textarea>
</td>
</tr>
<tr>
<td width="39%"> </td>
</tr>
<tr>
<td width="39%" height="13">Andres Kommentar:</td>
<td width="61%" rowspan="2">
<textarea name="textarea" rows="8" cols="30" class="box"><?php echo $row['andre']; ?></textarea>
</td>
</tr>
<tr>
<td width="39%"> </td>
</tr>
</table>
<input type="submit" value="Gem Ændringer" class="submit">
</form>
