redigere enkel række i tabel

Det er hovedsagligt et spørgsmål om SQL-kald.
SELECT, UPDATE og INSERT.

Skal du have lavet alting fra bunden eller har du lavet noget som du ike kan få til at virke du kan vise?

--
pacroon

Det er skriv filen...

<?
include("connect.php");

$getnews = mysql_query("select * from flatov");
while($r=mysql_fetch_array($getnews)){
extract($r);

}
?>

<div class="font10">
<form action="gemprofil.php" method="post">
<table border="0" cellpadding="5" cellspacing="0" align="center">
<tr><td align="left" class="tagwallwrite">Nick:</td><td colspan="2"><input type="text" class="input" name="nick" size="53" maxsize="100" value="<? echo("$nick"); ?>"></td></tr>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite" colspan="2">Personal Information</td></tr>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite">Irl Name:</td><td colspan="2"><input type="text" class="input" name="irl" size="53" maxsize="100" value="<? echo("$irl"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Age:</td><td colspan="2"><input type="text" class="input" name="age" size="53" maxsize="100" value="<? echo("$age"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">City:</td><td colspan="2"><input type="text" class="input" name="city" size="53" maxsize="100" value="<? echo("$city"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Country:</td><td colspan="2"><input type="text" class="input" name="country" size="53" maxsize="100" value="<? echo("$country"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">E-Mail:</td><td colspan="2"><input type="text" class="input" name="quote" size="53" maxsize="100" value="<? echo("$email"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Quote:</td><td colspan="2"><input type="text" class="input" name="quote" size="53" maxsize="100" value="<? echo("$quote"); ?>"></td></tr>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite" colspan="2">Game Information</td>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite">Primary Weapon:</td><td colspan="2"><input type="text" class="input" name="primary" size="53" maxsize="100" value="<? echo("$primary"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Secondary Weapon:</td><td colspan="2"><input type="text" class="input" name="secondary" size="53" maxsize="100" value="<? echo("$secondary"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Favorit Map:</td><td colspan="2"><input type="text" class="input" name="map" size="53" maxsize="100" value="<? echo("$map"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Sensitivity:</td><td colspan="2"><input type="text" class="input" name="sens" size="53" maxsize="100" value="<? echo("$sens"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">InGame Resolution:</td><td colspan="2"><input type="text" class="input" name="resolution1" size="53" maxsize="100" value="<? echo("$resolution1"); ?>"></td></tr>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite" colspan="2">Computer Information</td>
<tr><td colspan="3"><hr class="normalhr"><td></tr>
<tr><td align="left" class="tagwallwrite">CPu:</td><td colspan="2"><input type="text" class="input" name="cpu" size="53" maxsize="100" value="<? echo("$cpu"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Monitor:</td><td colspan="2"><input type="text" class="input" name="monitor" size="53" maxsize="100" value="<? echo("$monitor"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Memory:</td><td colspan="2"><input type="text" class="input" name="memory" size="53" maxsize="100" value="<? echo("$memory"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">GFX:</td><td colspan="2"><input type="text" class="input" name="gfx" size="53" maxsize="100" value="<? echo("$gfx"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Os:</td><td colspan="2"><input type="text" class="input" name="os" size="53" maxsize="100" value="<? echo("$os"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Mouse:</td><td colspan="2"><input type="text" class="input" name="mouse" size="53" maxsize="100" value="<? echo("$mouse"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Mousepad:</td><td colspan="2"><input type="text" class="input" name="pad" size="53" maxsize="100" value="<? echo("$pad"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Resolution:</td><td colspan="2"><input type="text" class="input" name="resolution2" size="53" maxsize="100" value="<? echo("$resolution2"); ?>"></td></tr>
<tr><td align="left" class="tagwallwrite">Connection:</td><td colspan="2"><input type="text" class="input" name="connection" size="53" maxsize="100" value="<? echo("$connection"); ?>"></td></tr>
<tr><td align="center" colspan="3"><input class="button" type="submit" value="Skriv"></td></tr>
</table>
</form>
</div>


her er gem filen...

$nick = $_POST["nick"];
$irl = $_POST["irl"];
$age = $_POST["age"];
$city = $_POST["city"];
$country = $_POST["country"];
$email = $_POST["email"];
$primary = $_POST["primary"];
$secondary = $_POST["secondary"];
$map = $_POST["map"];
$sens = $_POST["sens"];
$resolution1 = $_POST["resolution1"];
$cpu = $_POST["cpu"];
$monitor = $_POST["monitor"];
$memory = $_POST["memory"];
$gfx = $_POST["gfx"];
$os = $_POST["os"];
$mouse = $_POST["mouse"];
$pad = $_POST["pad"];
$resolution2 = $_POST["resolution2"];
$connection = $_POST["connection"];
//henter mysql info
include("connect.php");
$addnews =MYSQL_QUERY("INSERT INTO flatov(nick,irl,age,city,country,email,quote,primary,secondary,map,sens,resolution1,cpu,monitor,memory,gfx,os,mouse,pad,resolution2,connection)". "VALUES ('$nick', '$irl', '$age', '$city', '$country', '$email', '$quote', '$primary', '$secondary', '$map', '$sens', '$resolution1', '$cpu', '$monitor', '$memory', '$gfx', '$os', '$mouse', '$pad', '$resolution2', '$connection')");

?>


Jeg vil bare ikke have den indsætter en ny række, men bare overskriver den gamle..

Det gør du ved at ændre INSERT statementet til UPDATE :)

--
pacroon

altså bare UPDATE INTO flatov istedet for INSERT INTO eller ?

Lukker