Fejl i ret profil

hmm... nu er den så blevet postede 2gange...

kode er:

----------Script start-----------
<?php
session_start();
if($_SESSION[tjek] !== "OK") {
header("Location: ../index.php"); //vidresender brugern til den side du ønsker
} else {
include("db.php");
$row = mysql_query("SELECT * FROM film_users WHERE usr_name = '$_SESSION[usr_name]'");
$quake = mysql_fetch_array($row);
?>
<DIV STYLE="text-align:center">
<form action="?func=update" method="POST">
<FONT FACE="Verdana" SIZE="1" COLOR="#FFFFFF">
<BR>
<b><font color=''><?PHP echo "$_SESSION[usr_name]" ?> :</b></font><br>
<input type="text" class="texter" name="irl_name" value="<? echo $quake[irl_name] ?>"><br>
<input type="text" class="texter" name="usr_name" value="<? echo $_SESSION[usr_name] ?>"><br>
<input type="text" class="texter" name="usr_password" value="<? echo $quake[usr_password] ?>"><br>
<INPUT TYPE="submit" VALUE="Gem" CLASS="knap" STYLE="background-color: transparent; color: #008080">
</form>
<?
}
?>


<BODY STYLE="background-color:transparent" leftmargin="0" marginheight="0" marginwidth="0" topmargin="0">

<?php //Funktionen der updater oplysningerne
function update() {
include("db.php");
$row2 = mysql_query("SELECT * FROM film_users WHERE usr_name = '$_SESSION[usr_name]'");
$quake2 = mysql_fetch_array($row2);
mysql_query("UPDATE film_users set usr_password = '$usr_password' where usr_name = '$_POST[usr_name]'");
mysql_query("UPDATE film_users set irl_name = '$irl_name' where usr_name = '$_POST[usr_name]'");
echo "<FONT FACE=Verdana SIZE=1 COLOR=#000000>Vent Opdater Info...</FONT>";
?>
<script>
location.href = 'profil.php';
</script>
<?PHP
}
if($_GET['func'] == "update") {
    update();
}
?>
-------Script Slut----------

Hvilken slags fejl forekommer?? Syntaks fejl eller opdatere den ikke som den skal???

Skal update funktion ikke vide at du gerne vil ha variabler med ?

Måske noget i den her retning:

update($_POST[usr_password],$_POST[usr_name],$_POST[irl_name]);

der kommer ingen fejl, de opdater bare ikke som den skal... + $_POST[usr_name] skal være $_SESSION[usr_name]... Hvis jeg klikker på "Gem" jamen så retter den password og irl_name til "" altså ingen ting, der er bare tomt i den del af db'en...

hindu_skp: => denne funktion virker på alle andre ting, i min database, så tror ikke det er der fejlen ligger, men jeg har bytte => WHERE usr_name = '$_SESSION[usr_name]'");
med where id = '$id'"); <= som er den funktion jeg bruger på min andre ting...

Du spørger:
<?PHP
}
if($_GET['func'] == "update") {

men bruger method="post" i din formular. Prøv med en get

<?php //Funktionen der updater oplysningerne
function update() {
include("db.php");
$row2 = mysql_query("SELECT * FROM film_users WHERE usr_name = '$_SESSION[usr_name]'") or die (mysql_error());
$quake2 = mysql_fetch_array($row2);
mysql_query("UPDATE film_users set usr_password = '$usr_password', irl_name = '$irl_name' where usr_name = '$_POST[usr_name]'") or die (mysql_error());
?>
<script>
location.href = 'profil.php';
</script>
<?PHP
}
if($_GET['func'] == "update") {
    update();
}
?>

eller jeg ved ikke om der skal stå $_SESSION[usr_name] eller $_POST[usr_name]...

altså  <form action="?func=update" method="GET"> ?

altså


---------------
<?php
session_start();
if($_SESSION[tjek] !== "OK") {
header("Location: ../index.php"); //vidresender brugern til den side du ønsker
} else {
include("db.php");
$row = mysql_query("SELECT * FROM film_users WHERE usr_name = '$_SESSION[usr_name]'");
$quake = mysql_fetch_array($row);
?>
<DIV STYLE="text-align:center">
<form action="?func=update" method="GET">
<FONT FACE="Verdana" SIZE="1" COLOR="#FFFFFF">
<BR>
<b><font color=''><?PHP echo "$_SESSION[usr_name]" ?> :</b></font><br>
<input type="text" class="texter" name="irl_name" value="<? echo $quake[irl_name] ?>"><br>
<input type="text" class="texter" name="usr_name" value="<? echo $_SESSION[usr_name] ?>"><br>
<input type="text" class="texter" name="usr_password" value="<? echo $quake[usr_password] ?>"><br>
<INPUT TYPE="submit" VALUE="Gem" CLASS="knap" STYLE="background-color: transparent; color: #008080">
</form>
<?
}
?>

<BODY STYLE="background-color:transparent" leftmargin="0" marginheight="0" marginwidth="0" topmargin="0">

<?php //Funktionen der updater oplysningerne
function update() {
include("db.php");
$row2 = mysql_query("SELECT * FROM film_users WHERE usr_name = '$_SESSION[usr_name]'") or die (mysql_error());
$quake2 = mysql_fetch_array($row2);
mysql_query("UPDATE film_users set usr_password = '$usr_password', irl_name = '$irl_name' where usr_name = '$_SESSION[usr_name]'") or die (mysql_error());
?>
<script>
location.href = 'profil.php';
</script>
<?PHP
}
if($_GET['func'] == "update") {
    update();
}
?>
------------------

Går ud fra at $_SESSION["usr_name"] er sat, og ville nok gøre så'n:

<?php
session_start();

if(!isset($_SESSION["tjek"]) || $_SESSION["tjek"] != "OK") {
header("Location: ../index.php"); //vidresender brugern til den side du ønsker
exit();

} else {

include("db.php");


if(isset($_POST["update"])) {
mysql_query("UPDATE `film_users` set `usr_password` = '". $_POST["usr_password"] ."', `irl_name` = '". $_POST["irl_name"] ."' WHERE `usr_name` = '". $_SESSION["usr_name"] ."'") or die (mysql_error());
header("Location:profil.php");
exit();
}


$row = mysql_query("SELECT * FROM `film_users` WHERE `usr_name` = '". $_SESSION["usr_name"] ."'") or die (mysql_error());
$quake = mysql_fetch_array($row);
?>
<BODY STYLE="background-color:transparent" leftmargin="0" marginheight="0" marginwidth="0" topmargin="0">

<DIV STYLE="text-align:center">
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="POST">
<input type="hidden" name="update" value="true">

<FONT FACE="Verdana" SIZE="1" COLOR="#FFFFFF">
<BR>
<b><font color=''><?php echo $_SESSION["usr_name"]; ?> :</b></font><br>
<input type="text" class="texter" name="irl_name" value="<?php echo $quake["irl_name"]; ?>"><br>
<input type="text" class="texter" name="usr_name" value="<?php echo $_SESSION["usr_name"]; ?>"><br>
<input type="text" class="texter" name="usr_password" value="<?php echo $quake["usr_password"]; ?>"><br>
<INPUT TYPE="submit" VALUE="Gem" CLASS="knap" STYLE="background-color: transparent; color: #008080">
</form>
<?php
}
?>

Jeg kan ikke finde så meget rundt i den her kode men jeg poste et script som virker, et jeg selv bruger til at rette film med..

<?PHP
session_start();
/*
*    +-----------------------------------------------------------------------------+
*        Projekt Name:    Show products
*    +-----------------------------------------------------------------------------+
*        Copyright Notes: Copyrights 2003 pc-dk.dk
*    +-----------------------------------------------------------------------------+
*      Disclaimer Notice(s)                                                         
*      DONT USE THIS SCRIPT UNLESS YOU HAVE MY PERMISSIONS ON PARER     
*      WITH MY PERSONAL SIGNATURE ANY QUESTIONS FOR THAT
*      SEND ME A MAIL: TLARSEN@PC-DK.DK                                                                   
*      IF YOU WANT TO USE THIS SCRIPT THEN MAIL ME AND PAY FOR IT
*    +-----------------------------------------------------------------------------+
*        Author(s): Thomas Larsen / Dk-Medieburner E-Mail: Tlarsen@pc-dk.dk
*    +-----------------------------------------------------------------------------+
*/

    #error_reporting(E_ALL); //For debuggin only, prints all error!   
                            //remove the # to debug

/**
*    Module comments (Brief shorly what this piece of code do)
    This script is WHAT EVER YOU WANT IT TO DO
*/

    //includes the file there is openings a connection to a database
    include_once("dbconnect.php");

/*
    Here starts the code
*/
if($_SESSION['tjek'] !== "OK") {
    header("location:http://www.pc-dk.dk/video2/");
} else {

//selects the kategories from the database
$kat_res = mysql_query("SELECT * FROM kategori") or die(mysql_error());
//runs the $kat_res trough a while statement
while ($row_1[] = mysql_fetch_array($kat_res));
//remove the last item in the $row_1[] array
array_pop($row_1);

//----------------------------------------------------------------------//

//Select the movies from the database there is matching the $_GET['film_id']
$film_res = mysql_query("SELECT * FROM film WHERE id = '$_GET[id]'") or die(mysql_error());
//runs the $res trough a while statement
while ($row_2[] = mysql_fetch_array($film_res));
//remove the last item in the $row_2[] array
array_pop($row_2);

//----------------------------------------------------------------------//


//to avoid a warning i am setting $fail to emty here
$fail = "";
//if the user press the submit button named "change" -->
if (isset($_POST['change']))
{
    //insert the data from the form field
    mysql_query("UPDATE film set titel = '$_POST[titel]', type = '$_POST[type]', beskrivelse = '$_POST[beskrivelse]', kategori = '$_POST[kategori]', lengde = '$_POST[lengde]', aar = '$_POST[aar]', status = '$_POST[status]', note = '$_POST[note]' WHERE id = '$_POST[id]'") or die(mysql_error());
    print "<script>parent.top.location.href='../index.php'</script>";
}//ends else

   

/*
    Here stops the code
    if you have any html
    write it belowe here
*/
?>

<html>
    <head>
        <title></title>
        <link rel="stylesheet" type="text/css" href="../style.css">
    </head>
   
    <body background="">
    <form action="change.php" method="POST">
    <table>
    <?php
    foreach ($row_2 as $film) {
        ?>
        <tr>
            <td>Titel</td>
        </tr>
       
        <tr>
            <td><input type="text" name="titel" id="txt_box" value="<?PHP echo $film['titel']; ?>"></td>
        </tr>
       
        <tr>
            <td>Type</td>
        </tr>
       
        <tr>
            <td>
                <select name="type">
                    <option>Kopi</option>
                    <option>Orginal</option>
                </select>
            </td>
        </tr>
       
        <tr>
            <td>Beskrivelse</td>
        </tr>
       
        <tr>
            <td><textarea name="beskrivelse" id="text_area"><?php echo $film['beskrivelse']; ?></textarea></td>
        </tr>
       
        <tr>
            <td>Kategori</td>
        </tr>
       
        <tr>
            <td>
                <select name="kategori">
                <?php
                foreach ($row_1 as $kat) {
                    ?>
                    <option value="<?php echo $kat['kategori']; ?>"><?php echo $kat['kategori']; ?></option>
                    <?php
                }//ends foreach
                ?>
                </select>
            </td>
        </tr>
       
        <tr>
            <td>Længde</td>
        </tr>
       
        <tr>
            <td><input type="text" name="lengde" id="txt_box" value="<?PHP echo $film['lengde']; ?>"></td>
        </tr>
       
        <tr>
            <td>År</td>
        </tr>
       
        <tr>
            <td><input type="text" name="aar" id="txt_box" value="<?PHP echo $film['aar']; ?>"></td>
        </td>
       
        <tr>
            <td>Ejer</td>
        </tr>
       
        <tr>
            <td><input type="text" name="ejer" id="txt_box" value="<?PHP echo $film['ejer']; ?>" readonly></td>
        </tr>
       
        <tr>
            <td>Status</td>
        </tr>
       
        <tr>
            <td>
                <select name="status">
                    <option>På hylden</option>
                    <option>På harddisk</option>
                    <option>Udlånt</option>
                </select>
            </td>
        </tr>
       
        <tr>
            <td>Note</td>
        </tr>
       
        <tr>
            <td><textarea name="note" id="text_area"><?php echo $film['note']; ?></textarea></td>
        </tr>
       
        <tr>
            <td><input type="submit" name="change" id="submit_knap" value="Ændre filmen"></td>
        </tr>
       
        <tr>
            <td><?php echo "$fail"; ?></td>
        </tr>
       
        <tr>
            <td><input type="hidden" name="id" value="<?PHP echo $_GET['id']; ?>"></td>
        </tr>
       
       
       
        <?php
    }
}
    ?>
    </table>
    </form>
   
    </body>
</html>

< -- Selve afstemningen. Kan indsættes på alle sider - F. eks. under din menu. -- >

<?php
########## POLL QUESTION ##########

echo "<form action=\"poll.php?action=vote\" method=\"post\">\n";
echo "<table>\n";

$conn = mysql_connect("server", "brugernavn", "kodeord");
mysql_select_db("database");
$result = mysql_query("select * from pollquestion WHERE start <= now() AND end >= now()");
while ($row = mysql_fetch_array($result)) {
  echo "<tr><td>" . htmlentities($row[question]) . "</td></tr>\n";

  $questionid = $row[questionid];
}

########## POLL ANSWERS ##########

$result = mysql_query("select * from pollanswer WHERE questionid = '$questionid'");
while ($row = mysql_fetch_array($result)) {
  echo "<tr><td><input type=\"hidden\" name=\"id\" value=\"" . $row["id"] . "\">" . $row["answer"]</td></tr>\n";
}

echo "<tr><td><input type=\"hidden\" name=\"questionid\" value=\"$questionid\">\n";
echo "<input type=\"submit\" value=\"Stem\"></td></tr>\n";
echo "</table>\n";
echo "</form>\n";
?>

< -- POLL.PHP -- >

<?php
########## POLL QUESTION ##########

echo "<table>\n";

$conn = mysql_connect("server", "brugernavn", "kodeord");
mysql_select_db("database");
$result = mysql_query("select * from pollquestion WHERE start <= now() AND end >= now()");
while ($row = mysql_fetch_array($result)) {
  echo "<tr><td colspan=\"2\">" . htmlentities($row["Navn"]) . "</td></tr>\n";

  $id = $row["questionid"];
}

########## SUM OF POLLANSWERS ##########

$result = mysql_query("select sum(hits) as sum from pollanswer where questionid = '$questionid'");
while ($row = mysql_fetch_array($result)) {
  $sum = $sum;

  echo "<tr><td colspan=\"2\">$sum stemme(r)</td></tr>\n";
}

$result = mysql_query("select * from pollanswer WHERE questionid = '$questionid'");
while ($row = mysql_fetch_array($result)) {
  $percent = 0;
  if($hits > 0) {
    $percent = ($hits * 100) / $sum;
  }
    echo "<tr><td>" . htmlentities($row["answer"]) . "</td>";
    echo "<td>" . $percent . "%</td></tr>\n";
}

mysql_close($conn);

echo "</table>\n";

########## VOTE ##########
// INDSÆTTES I BUNDEN AF POLL.PHP

if($_REQUEST[action] == "vote") {
  $conn = mysql_connect("server", "brugernavn", "kodeord");
  mysql_select_db("database");
  mysql_query("UPDATE pollanswer SET hits = hits + 1 WHERE questionid = '$_REQUEST[questionid]' AND id = '$_REQUEST[id]'");
  mysql_close($conn);
}
?>

/lukker