wieso funktioniert diese update anweisung nicht:
<?php
include "connect.inc.php";
$sqlab = "select * from user where pw like '$pw'";
$res = mysql_query($sqlab);
$dsatz = mysql_fetch_assoc($res);
{
echo "
Dein bisheriges Profil</p>";
echo "<form action = 'andern2.php' method = 'post'>";
echo "<input name='nick' value='" . $dsatz["nick"] . "'>Nicht ändern!!</br>";
echo "<input name='name' value='" . $dsatz["name"] . "'>Name</br>";
echo "<input name='pw' value='" . $dsatz["pw"] . "'>Passwort</br>";
echo "<input name='email' value='" . $dsatz["email"] . "'>E-Mail Adresse </br>";
echo "<input name='alter' value='' size='5'" . $dsatz["alter"] . "'>Dein Alter </br>";
echo "<input name='love' value='' size='25'" . $dsatz["love"] . "'>Du liebst.. </br>";
echo "<input name='hate' value='' size='25'" . $dsatz["hate"] . "'>Du hasst.. </br>";
echo "<input name='hp' value='" . $dsatz["hp"] . "'>Homepage</br>";
echo "<input name='day' value='' size='3'" . $dsatz["day"] . "'>";
echo "<input name='month' value='' size='3'" . $dsatz["month"] . "'>";
echo "<input name='year' value='' size='3'" . $dsatz["year"] . "'>Geburtsdatum: dd:mm:YYYY</br>";
echo "<input type='submit' value='Profil ändern'> ";
echo "<input type='reset' value='Clear'>";
echo "</form>";
}
?>
und auswertung:
<?php
include "connect.inc.php";
$sqlab = "update user set mail = $mail,";
$sqlab .= " pw = $pw,";
$sqlab .= " alter = $alter,";
$sqlab .= " love = $love,";
$sqlab .= " hate = $hate,";
$sqlab .= " hp = $hp,";
$sqlab .= " day = $day,";
$sqlab .= " month = $month,";
$sqlab .= " year = $year";
$sqlab .= " where nick = '$nick'";
mysql_query($sqlab);
$num = mysql_affected_rows();
if ($num==1)
echo " Profiländerung erfolgreich";
else
echo " Änderung erfolgreich";
?>
<?php
include "connect.inc.php";
$sqlab = "select * from user where pw like '$pw'";
$res = mysql_query($sqlab);
$dsatz = mysql_fetch_assoc($res);
{
echo "
Dein bisheriges Profil</p>";
echo "<form action = 'andern2.php' method = 'post'>";
echo "<input name='nick' value='" . $dsatz["nick"] . "'>Nicht ändern!!</br>";
echo "<input name='name' value='" . $dsatz["name"] . "'>Name</br>";
echo "<input name='pw' value='" . $dsatz["pw"] . "'>Passwort</br>";
echo "<input name='email' value='" . $dsatz["email"] . "'>E-Mail Adresse </br>";
echo "<input name='alter' value='' size='5'" . $dsatz["alter"] . "'>Dein Alter </br>";
echo "<input name='love' value='' size='25'" . $dsatz["love"] . "'>Du liebst.. </br>";
echo "<input name='hate' value='' size='25'" . $dsatz["hate"] . "'>Du hasst.. </br>";
echo "<input name='hp' value='" . $dsatz["hp"] . "'>Homepage</br>";
echo "<input name='day' value='' size='3'" . $dsatz["day"] . "'>";
echo "<input name='month' value='' size='3'" . $dsatz["month"] . "'>";
echo "<input name='year' value='' size='3'" . $dsatz["year"] . "'>Geburtsdatum: dd:mm:YYYY</br>";
echo "<input type='submit' value='Profil ändern'> ";
echo "<input type='reset' value='Clear'>";
echo "</form>";
}
?>
und auswertung:
<?php
include "connect.inc.php";
$sqlab = "update user set mail = $mail,";
$sqlab .= " pw = $pw,";
$sqlab .= " alter = $alter,";
$sqlab .= " love = $love,";
$sqlab .= " hate = $hate,";
$sqlab .= " hp = $hp,";
$sqlab .= " day = $day,";
$sqlab .= " month = $month,";
$sqlab .= " year = $year";
$sqlab .= " where nick = '$nick'";
mysql_query($sqlab);
$num = mysql_affected_rows();
if ($num==1)
echo " Profiländerung erfolgreich";
else
echo " Änderung erfolgreich";
?>
Kommentar