no error but it dont work

[hwoarang69]

i have no error in this code but this dont work. when i run this i see all the buttons and filds but when i chick a button nothing happens. i think making a submit button mistake some where.

<?php
session_start();
$user2 = $_SESSION['user'];

if($user2)
{
	//user is logged in
	if(isset($_POST['submit']))
	{
		//checkfields
		$oldpassword = $_POST['oldpassword'];
		$newpassword = $_POST['newpassword'];
		$repeatnewpassword = $_POST['repeatnewpassword'];
		echo $oldpassword;

	//connect db
	$connect = mysql_connect("localhost",   "root",     "") or die("couldnt connect to data base");
	mysql_select_db("uploadsite") or die("couldnt connect to date base");
	$queryget = mysql_query("SELECT password FROM users WHERE username ='$user2'") or die("query didnt work");
	$row = mysql_fetch_assoc($queryget);	
	$oldpassworddb = $row['password'];


		//check old password
		if($oldpassword == $oldpassworddb)
		{
				//check two new passwords
			if($newpassword == $repeatnewpassword)
			{
				//put new password in data base
				$querychange = mysql_query("
				UPDATE users SET password='$newpassword' WHERE username='$user2'");
				session_destroy();
				die("Your password has been changed. <a href='index.php'>Return</a> to the main page");
			}
			else
				die("New password dont match");

		}
		else
			die("Old password dont match");
	}
else
{
	echo"
<form action='changepassword.php' method='POST'>
	Old password: <input type='text' name='oldpassword'><p>
	New password: <input type='password' name='newpassword'><p>
	Rpeat password: <input type='password' name='repeatnewpassword'><p>
	<input type='submit' name='sumbit' value='Change password'>
	</form>
";
}
}
else
	die("you must be logged in to change your password!");
?>

[johanafm]

Yes, you've made exactly the misstake you suspected you did. Maybe by inspecting the post data you will see what you don't in your code

if($user2)
{
    printf('<pre>&#37;s</pre>', print_r($_POST,1));
    //user is logged in
    if(isset($_POST['submit']))
    {

[hwoarang69]

it gives me this. it seem like its working fine. but when i logg off and try my new password it dont work. any ideas?

Array
(
[oldpassword] => asdasd
[newpassword] => 123456
[repeatnewpassword] => 123456
[sumbit] => Change password
)
Old

[bradgrafelman]

You should be checking to see if [man]mysql_query/man returns boolean FALSE, indicating that an error has occurred, and then either output or log detailed error information (such as the error message returned by the MySQL server).