nem redigering

jo, hent det ud med en query og smid det i nogle <input type=text> og smid det tilbage.

$res = mysql_query("SELECT * FROM users where username = '$authenticatedUser'") ;

    $number = @mysql_num_rows($res);
    $row = @mysql_fetch_assoc($res);


$email = $row["email"];
$adr = $row["address"];
$navn = $row["fullname"];
$postnr = $row["zipcode"];
$phonenr = $row["phone"];
$pwd= $row["password"];

kan du ikke lige komme med et eks. er lidt lost lige nu. og er Noob

if(isset($_POST['rediger']))
{
//Lav en update af alle data via en UPDATE i sql.
}

$res = mysql_query("SELECT * FROM users where username = '$authenticatedUser'") ;

$number = @mysql_num_rows($res);
$row = @mysql_fetch_assoc($res);

$email = $row["email"];
$adr = $row["address"];
$navn = $row["fullname"];
$postnr = $row["zipcode"];
$phonenr = $row["phone"];
$pwd= $row["password"];

echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">";
echo "<input type=\"text\" name=\"email\" value=\"".$email."\">";
osv....
echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">";
echo "</form>";

men den vil ikke godtage min update

<?php
include(realpath("./include") . "./inc/db.inc");

session_start(  );

if(isset($_POST['rediger']))
{
  $res = ("INSERT INTO users ( fullname, username, password, email, address, zipcode, phone) where username = '$authenticatedUser'")
VALUES ('$fullname', '$username', '$password', '$email', '$address', '$zipcode', '$phone')") ;

mysql_query($res)or die (mysql_error());
}

  $res = mysql_query("SELECT * FROM users where username = '$authenticatedUser'") ;
$number = @mysql_num_rows($res);
$row = @mysql_fetch_assoc($res);

$email = $row["email"];
$address = $row["address"];
$navn = $row["fullname"];
$zipcode= $row["zipcode"];
$phone = $row["phone"];
$password= $row["password"];


echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">";
echo "<input type=\"text\" name=\"email\" value=\"".$email."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$address."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$navn."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$zipcode."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$phone."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$password."\">";

echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">";
echo "</form>";

nu har jeg fået den lavet men det er som om den ikke har de rigtige værdier den hopper bare til hovedsiden når man trykke på knappen



<?php
include(realpath("./include") . "./inc/db.inc");

session_start(  );

if(isset($_POST['rediger']))
{
$res = ("UPDATE users set ( fullname, username, password, email, address, zipcode, phone) where username = '$authenticatedUser'
VALUES ('$fullname', '$username', '$password', '$email', '$address', '$zipcode', '$phone')") ;


echo $res ;
#mysql_query ($res) or die (mysql_error());
}

  $res = mysql_query("SELECT * FROM users where username = '$authenticatedUser'") ;

$number = @mysql_num_rows($res);
$row = @mysql_fetch_assoc($res);

$email = $row["email"];
$address = $row["address"];
$navn = $row["fullname"];
$zipcode= $row["zipcode"];
$phone = $row["phone"];
$password= $row["password"];


echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">";
echo "<input type=\"text\" name=\"email\" value=\"".$email."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$address."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$navn."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$zipcode."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$phone."\">";
echo "<input type=\"text\" name=\"email\" value=\"".$password."\">";

echo "<input type=\"submit\" name=\"rediger\" value=\"Rediger\">";
echo "</form>";

lukker