Hjælp til tabel update
Hejsa,Jeg kan ikke forstå hvad der er galt i denne update? Nogle der kan hjælpe mig med hvorfor tabellen ikke opdateres?
<?php
include("settings.php");
include("header.php");
include("menu.php");
if(isset($_SESSION['username']) && isset($_SESSION['userlevel'])) {
?>
<div>
<table align="center" width="550">
<?php
if ($_POST['edit']) {
$username = $_SESSION['username'];
$email = $_POST['email'];
$city = addslashes($_POST['city']);
$club = addslashes($_POST['club']);
$player = addslashes($_POST['player']);
$year = $_POST['year'];
$month = $_POST['month'];
$day = $_POST['day'];
$update = mysql_query("UPDATE users SET email='$email', city='$city', age='$year-$month-$day', favouriteClub='$club', favouritePlayer='$player' WHERE username='$username')");
$output='<tr><td>Din profil er nu ændret og du kan se den <a href="profile.php?id='.$_SESSION['username'].'"><strong>her</strong></a>.</td></tr>';
}
else {
$username = $_SESSION['username'];
$result = mysql_query("SELECT *,
DATE_FORMAT(age, '%Y') AS year,
DATE_FORMAT(age, '%m') AS month,
DATE_FORMAT(age, '%d') AS day FROM users WHERE username='$username'");
$r = mysql_fetch_array($result);
$r[email] = stripslashes($r[email]);
$r[city] = stripslashes($r[city]);
$r[favouriteClub] = stripslashes($r[favouriteClub]);
$r[favouritePlayer] = stripslashes($r[favouritePlayer]);
$output='
<form method="post" action="'.$_SERVER["PHP_SELF"].'?id='.$_SESSION['username'].'">
<tr>
<td colspan="2"><strong>Opdater profil for '.$username.':</strong><br><br></td>
</tr>
<tr>
<td>E-mail:</td>
<td align="right" style="padding-right: 15px;"><input type="text" name="email" size="80" value="'.$r[email].'"></td>
</tr>
<tr>
<td>By:</td>
<td align="right" style="padding-right: 15px;"><input type="text" name="city" size="80" value="'.$r[city].'"></td>
</tr>
<tr>
<td>Fødselsdato:</td>
<td align="right" style="padding-right: 15px;">
<select name="day">
<option value="'.$r[day].'">'.$r[day].'</option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="month">
<option value="'.$r[month].'">'.$r[month].'</option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
<select name="year">
<option value="'.$r[year].'">'.$r[year].'</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
<option value="1946">1946</option>
<option value="1945">1945</option>
<option value="1944">1944</option>
<option value="1943">1943</option>
<option value="1942">1942</option>
<option value="1941">1941</option>
<option value="1940">1940</option>
<option value="1939">1939</option>
<option value="1938">1938</option>
<option value="1937">1937</option>
<option value="1936">1936</option>
<option value="1935">1935</option>
<option value="1934">1934</option>
<option value="1933">1933</option>
<option value="1932">1932</option>
<option value="1931">1931</option>
<option value="1930">1930</option>
</select>
</td>
</tr>
<tr>
<td>Favorit spiller:</td>
<td align="right" style="padding-right: 15px;"><input type="text" name="player" size="80" value="'.$r[favouritePlayer].'"></td>
</tr>
<tr>
<td>Favorit klub:</td>
<td align="right" style="padding-right: 15px;"><input type="text" name="club" size="80" value="'.$r[favouriteClub].'"></td>
</tr>
<tr>
<td></td>
<td align="right" style="padding-right: 15px;"><input type="submit" name="edit" value="Opdater profil"></td>
</tr>
</form>';
}
echo ''.$output.'';
?>
</table>
</div>
<?php
} else {
echo 'Du har ikke adgang til denne side!';
}
include("footer.php");
?>
