En tanke jeg fik "hvorfor gemmer du ikke alle oplysninger i samme tabel"??
Dernæst synes jeg ikke jeg har alle oplysninger om din database, så jeg tænkte at du kunne få en af mine filer også tilrette den. Dette er en komplet fil til oprettelse, rettelse og slet:
<?php
$conn = mysql_connect("aaaa", "bbb", "ccc");
mysql_select_db("DB");
$mode = "";
if(isset($_REQUEST["mode"]))
{
$mode = $_REQUEST["mode"];
}
$url = $_SERVER["SCRIPT_NAME"];
$bID = $_REQUEST["bID"];
if($mode == "save")
{
$username = $_REQUEST["username"];
$pass = $_REQUEST["pass"];
$name = $_REQUEST["name"];
$email = $_REQUEST["email"];
if($bID != "")
{
$sql = "update players set username='$username', pass='$pass', name='$name', email='$email' where id=$bID ";
mysql_query($sql);
}
else
{
$sql = "insert into players(username,pass,name,email) values('$username','$pass','$name','$email')";
mysql_query($sql);
}
echo mysql_error();
mysql_close($conn);
header("location: $url");
exit;
}
elseif($mode == "del")
{
if($bID != "")
{
mysql_query("delete from players where id=$bID");
}
mysql_close($conn);
header("location: $url");
exit;
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Bruger</title>
<link rel="STYLESHEET" type="text/css" href="style.css">
</head>
<body>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function send(mode)
{
if(mode == 'del')
{
if(window.confirm("Vil du slette brugeren?"))
{
document.form.action = '<?php echo $url ?>?mode='+mode;
document.form.submit();
}
}
else
{
document.form.action = '<?php echo $url ?>?mode='+mode;
document.form.submit();
}
}
//-->
</SCRIPT>
<form name="form" action="" method="post">
<?php
if($mode == "new" or $mode == "edit")
{
if($mode == "edit")
{
if($bID != "")
{
$result = mysql_query("select * from players where id=$bID");
if($row = mysql_fetch_array($result))
{
extract($row);
}
}
}
?>
<input type="Hidden" name="bID" value="<?php echo $id; ?>">
<table>
<tr>
<td colspan="2" class="over">Ny Bruger</td>
</tr>
<tr>
<td>Navn:</td>
<td><input type="Text" name="name" value="<?php echo $name; ?>"></td>
</tr>
<tr>
<td>Brugernavn:</td>
<td><input type="Text" name="username" value="<?php echo $username; ?>"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="Text" name="pass" value="<?php echo $pass; ?>"></td>
</tr>
<tr>
<td>Email:</td>
<td><input type="Text" name="email" value="<?php echo $email; ?>"></td>
</tr>
<tr>
<td colspan="2" class="over">
<input type="Button" class="button" value="Gem" onclick="send('save')">
<input type="Button" class="button" value="Annuler" onclick="send('')">
</td>
</tr>
</table>
<?php
}
else
{
?>
<table>
<tr>
<td colspan="2" class="over">Bruger</td>
</tr>
<tr>
<td>Bruger:</td>
<td>
<select name="bID" onchange="send('');">
<?php $result = mysql_query("select * from players order by name");
while($row = mysql_fetch_array($result)){
if($bID == $row["id"])
{
echo "<option value=\"".$row["id"]."\" selected>".$row["name"];
extract($row);
$bID = $id;
}
else
{echo "<option value=\"".$row["id"]."\">".$row["name"];}
}
?>
</select>
</td>
</tr>
<?php
if($bID != "")
{
$result = mysql_query("select * from players where id=$bID");
if($row = mysql_fetch_array($result))
{
extract($row);
}
}
else
{
$result = mysql_query("select * from players order by name");
if($row = mysql_fetch_array($result))
{
extract($row);
}
}
?>
<tr>
<td>Brugernavn:</td>
<td><?php echo $username; ?> </td>
</tr>
<tr>
<td>Password:</td>
<td><?php echo $pass; ?> </td>
</tr>
<tr>
<td>Email:</td>
<td><?php echo $email; ?> </td>
</tr>
<tr>
<td colspan="2" class="over">
<input type="Button" class="button" value="Ny" onclick="send('new')">
<input type="Button" class="button" value="Slet" onclick="send('del')">
<input type="Button" class="button" value="Ret" onclick="send('edit')">
</td>
</tr>
</table>
<?php
}
?>
</form>
<?php
mysql_close($conn);
?>
</body>
</html>
ps. Jeg har klippet i filen, så måske har jeg klippet for meget, men jeg har gennemgået den, så den skulle være ok.
Bare sig til hvis der er noget af den du ikke forstår :o)
