Hey!
Litle bit of a problem..
I want my users to be able to change their timezone aswell as other stuff on the site. But for some reason whatever timezone they select from the list is always read by PHP as 0.
if(!$edited) {
$result = mysql_query("SELECT * FROM newrepublic_members WHERE ID = '$ID';");
$r = mysql_fetch_array($result);
echo "<form method=post action=\"$PHP_SELF?edit=1&edited=1\">";
echo "<table width=85%>";
echo "<tr><td width=25%><b>Username</b>: </td><td><input type=\"text\" name=\"username\" value=\"$r[username]\" size=30></td></tr>";
echo "<tr><td width=25%><b>Password</b>: </td><td><input type=\"password\" name=\"password\" size=30></td></tr>";
echo "<tr><Td width=25%><b>E-Mail</b>: </td><td><input type=\"text\" name=\"email\" value=\"$r[email]\" size=40></td></tr>";
echo "<tr><td width=25%><b>Location</b>: </td><Td><input type=\"text\" name=\"location\" value=\"$r[location]\" size=40></td></tr>";
echo "<tr><td valign=\"top\" width=25%><b>Time Zone</b>:</td><td>";
echo "<select name=\"timezone\">";
echo "<option value=10000>Please Select";
echo "<option value=-12>GMT - 12 Hours";
echo "<option value=-11>GMT - 11 Hours";
echo "<option value=-10>GMT - 10 Hours";
echo "<option value=-9>GMT - 9 Hours";
echo "<option value=-8>GMT - 8 Hours";
echo "<option value=-7>GMT - 7 Hours";
echo "<option value=-6>GMT - 6 Hours";
echo "<option value=-5>GMT - 5 Hours";
echo "<option value=-4>GMT - 4 Hours";
echo "<option value=-3>GMT - 3 Hours";
echo "<option value=-2>GMT - 2 Hours";
echo "<option value=-1>GMT - 1 Hours";
echo "<option value=0>GMT - (London UK)";
echo "<option value=1>GMT + 1 Hours";
echo "<option value=2>GMT + 2 Hours";
echo "<option value=3>GMT + 3 Hours";
echo "<option value=4>GMT + 4 Hours";
echo "<option value=5>GMT + 5 Hours";
echo "<option value=6>GMT + 6 Hours";
echo "<option value=7>GMT + 7 Hours";
echo "<option value=8>GMT + 8 Hours";
echo "<option value=9>GMT + 9 Hours";
echo "<option value=10>GMT + 10 Hours";
echo "<option value=12>GMT + 12 Hours";
echo "<option value=13>GMT + 13 Hours";
echo "</select><br><br>";
echo "</td></tr>";
echo "<tr><td valign=\"top\" width=25%><b>About Yourself</b>:</td><td><textarea cols=60 rows=20 name=\"about\">$r[about]</textarea></td></tr>";
echo "</table>";
echo "<br><br><input type=\"submit\" value=\" Update My Profile \">";
echo "</form>";
} else {
echo $timezone;
if($timezone == 10000) {
$password = md5($password);
$result = mysql_query("UPDATE newrepublic_members SET username = '$username', password = '$password', email = '$email', location = '$location', about = '$about' WHERE ID = '$ID';");
if($result) {
echo "Your changes have been saved!";
} else {
echo "ERROR!";
}
}
if($password == "") {
$result = mysql_query("UPDATE newrepublic_members SET username = '$username', email = '$email', location = '$location', about = '$about', timezone = '$timezone' WHERE ID = '$ID';");
if($result) {
echo "Your changes have been saved!";
} else {
echo "ERROR!";
}
} else {
$password = md5($password);
$result = mysql_query("UPDATE newrepublic_members SET username = '$username', password = '$password', email = '$email', location = '$location', timezone = '$timezone', about = '$about' WHERE ID = '$ID';");
if($result) {
echo "Your changes have been saved!";
} else {
echo "ERROR!";
}
}
}
All the other vaiables have values. The timezone section of the code is also used in the registration part of the site and works fine. What's going on?
Thanks, Stezz.
