Won't edit Query..

[Sesquipedalian]

I'm seriously confused.. I'm making a login, and I added an option so that I could edit users, It comes up with a list of the users in the database, I click one, it brings up the information into a form, and then I edit it.. Everything seems to work fine, there is no errors, nothing at all, when I made it display the SQL it came out with "1", so it should be working? But it doesn't edit the user.. I don't understand why..

Links to Users Function:

function editLinks() {
	echo '<center><font color="blue"><b>Select a user:</b></font><br /><br />';
		$query = sprintf("SELECT username, password FROM users");
        $result = mysql_query($query);
        if (!$result) {
             $message  = 'Invalid query: ' . mysql_error() . "\n";
             $message .= 'Whole query: ' . $query;
               die($message);
        }
        while ($row = mysql_fetch_assoc($result)) {
            echo '<a href="main.php?user='.$row['password'].'">'.$row['username'].'</a><br />';
        }
       mysql_free_result($result);
	}

Form Function:

function editForm($password) {
		$query = sprintf("SELECT username, password, email, rank FROM users WHERE password = '$password'");
        $result = mysql_query($query);
        if (!$result) {
             $message  = 'Invalid query: ' . mysql_error() . "\n";
             $message .= 'Whole query: ' . $query;
             die($message);
        }
        while ($row = mysql_fetch_assoc($result)) {
            echo '<center><font color="blue"><b>Edit User:</b></font><br /><br />'
				. '<form action="main.php" method="POST">'
				. '<b>Username:</b><br />'
				. '<input type="text" name="username" value="'.$row['username'].'" /><br /><br />'
				. '<b>Change Password:</b><br />'
				. '<input type="password" name="password" /><br /><br />'
				. '<b>Email:</b><br />'
				. '<input type="text" name="email" value="'.$row['email'].'" /><br /><br />'
				. '<b>Rank:</b><br />'
				. '<input type="text" name="rank" value="'.$row['rank'].'" />'
				. '<input type="hidden" name="initialPassword" value="'.$password.'" /><br />'
				. '<input type="submit" name="editSubmit" value="Edit User" />'
				. '</form></center>';
        }
       mysql_free_result($result);
	}

Process Function:

function editProcess($username, $password, $rank, $email, $intipassword) {
		mysql_query("UPDATE users SET username = '$username', password = '$password', rank = '$rank', email = '$email' WHERE password = '".$intipassword."'");;
		if (mysql_error() !== "") {
			echo '<center><b>Error:</b> <i>'.mysql_error().'</i></center>';
		} else if (!mysql_error()) {
			echo '<center><b>Success:</b> User was edited successfuly.</center>';
		}
	}

Call to Links Function:

else if ($_GET['panel_op'] == "edit") {
			$panel->editLinks();
		}

Call to Form Function:

else if (isset($_GET['user'])) {
		$panel->editForm($_GET['user']);
                }

Call to Process Function:

else if (isset($_POST['editSubmit'])) {
		$panel->editProcess($_POST['username'], md5($_POST['password']), $_POST['rank'], $_POST['email'], $_POST['intialpassword']);
	}

If you need me to give you the full files of each things just tell me. Thanks!

[iNFERiON]

Giving it a quick look I'd say here's where you go wrong:

function editProcess($username, $password, $rank, $email, $intipassword) {
        mysql_query("UPDATE users SET username = '$username', password = '$password', rank = '$rank', email = '$email' WHERE password = '".$intipassword."'");;

Mind the double ; at the end. This will most likely return a parse error, resulting in the function not working properly.

[Sesquipedalian]

Oh, that was an accident because I was switching something I wrote to make it echo the SQL, I removed one of the ;'s but it still doesn't edit?..

if_panel.php

<?
require('panel.php');
$panel = new panel();

if (isset($_GET)) {
	if (isset($_GET['session'])) {
		if ($_GET['session'] == "login") {
			$panel->homepage();
		} 
	} else if (isset($_GET['panel_op'])) {
		if ($_GET['panel_op'] == "register") {
			$panel->registerForm();
		} else if ($_GET['panel_op'] == "edit") {
			$panel->editLinks();
		}
	} else if (isset($_POST['registerSubmit'])) {
		$panel->registerProcess();
	} else if (isset($_GET['user'])) {
		$panel->editForm($_GET['user']);
	} else if (isset($_POST['editSubmit'])) {
		$panel->editProcess($_POST['username'], md5($_POST['password']), $_POST['rank'], $_POST['email'], $_POST['intialpassword']);
	}
} 
?>

panel.php

<?
require_once("require.php");
require_once(session);
require_once(config);
class panel {
	function homepage() {
		echo '<center><font color="blue"><b>Please Select an Option from Bellow:</b></font>';
		$this->ranks();
	}
	function ranks() {
		if ($_SESSION['rank'] == "1") {
			echo '<br /><br /><br /><b><i>Administrative options:</i></b><br />'
				. '<a href="main.php?panel_op=register">Register a Account</a><br />'
				. '<a href="main.php?panel_op=edit">Edit a User</a>';
		} else if ($_SESSION['rank'] == "2") {
			echo '<br /><br /><a href="main.php?panel_op=register">Register a Account</a><br />'
				. '<a href="main.php?panel_op=edit">Edit a User</a>';
		}
	}
	function registerForm() {
		echo '<center><b><font color="blue">Register:</b></font><br /><br /><br />'
		.  '<b>Username:</b><br />'
		. '<form action="main.php" method="POST">'
		. '<input type="text" name="username" /><br /><br />'
		. '<b>Password:</b><br />'
		. '<input type="password" name="password" /><br /><br />'
		. '<b>Email:</b><br />'
		. '<input type="text" name="email" /><br />'
		. '<input type="submit" name="registerSubmit" value="Register" />'
		. '</form></center>';
	}
	function registerProcess() {
		mysql_query("INSERT INTO users (username, password, email) VALUES ('".$_POST['username']."', '".md5($_POST['password'])."', '".$_POST['email']."')");
		if (mysql_error() !== "") {
			echo '<center><b>Error:</b> <i>'.mysql_error().'</i></center>';
		} else if (!mysql_error()) {	
			echo '<center><b>Success:</b> <i>User '.$_POST['username'].' was added.';
		}
	}
	function editForm($password) {
		$query = sprintf("SELECT username, password, email, rank FROM users WHERE password = '$password'");
        $result = mysql_query($query);
        if (!$result) {
             $message  = 'Invalid query: ' . mysql_error() . "\n";
             $message .= 'Whole query: ' . $query;
             die($message);
        }
        while ($row = mysql_fetch_assoc($result)) {
            echo '<center><font color="blue"><b>Edit User:</b></font><br /><br />'
				. '<form action="main.php" method="POST">'
				. '<b>Username:</b><br />'
				. '<input type="text" name="username" value="'.$row['username'].'" /><br /><br />'
				. '<b>Change Password:</b><br />'
				. '<input type="password" name="password" /><br /><br />'
				. '<b>Email:</b><br />'
				. '<input type="text" name="email" value="'.$row['email'].'" /><br /><br />'
				. '<b>Rank:</b><br />'
				. '<input type="text" name="rank" value="'.$row['rank'].'" />'
				. '<input type="hidden" name="initialPassword" value="'.$password.'" /><br />'
				. '<input type="submit" name="editSubmit" value="Edit User" />'
				. '</form></center>';
        }
       mysql_free_result($result);
	}
	function editProcess($username, $password, $rank, $email, $intipassword) {
		mysql_query("UPDATE users SET username = '$username', password = '$password', rank = '$rank', email = '$email' WHERE password = '".$intipassword."'");
		if (mysql_error() !== "") {
			echo '<center><b>Error:</b> <i>'.mysql_error().'</i></center>';
		} else if (!mysql_error()) {
			echo '<center><b>Success:</b> User was edited successfuly.</center>';
		}
	}
	function editLinks() {
	echo '<center><font color="blue"><b>Select a user:</b></font><br /><br />';
		$query = sprintf("SELECT username, password FROM users");
        $result = mysql_query($query);
        if (!$result) {
             $message  = 'Invalid query: ' . mysql_error() . "\n";
             $message .= 'Whole query: ' . $query;
             die($message);
        }
        while ($row = mysql_fetch_assoc($result)) {
            echo '<a href="main.php?user='.$row['password'].'">'.$row['username'].'</a><br />';
        }
       mysql_free_result($result);
	}
}

?>

[Sesquipedalian]

Nevermind, I got it to edit it, I'm not sure how though.. Does anyone know how I could reload a page without sending information to the header, because the headers are already being sent by session.php when I declare "session_start()"..?

[iNFERiON]

You can reload a page where you use sessions with javascript, like this:

<a href="#" onClick="javascript:location.reload();">Reload this page</a>

[Sesquipedalian]

Well.. err.. I want it to automatically reload the page without a link, and I also want it to only reload on one page, because when I logout it keeps the links unless it is refreshed under the login.

[Roger_Ramjet]

Not sure I follow you???

If it is keeping the 'links' ??? then you probably have a browser cache problem. But really, please try to explain yourself more clearly.