Help with edit profile

[hoponhiggo]

Hi

 

I am trying to develop an editprofile.php page to allow users to change their details.

 

So far i have written

 

<?php

$result = mysql_query("SELECT username FROM users WHERE username = {$_SESSION['MM_Username']}");

$num_rows = mysql_num_rows($result);
  
if($num_rows > 0)
{
	while ($row = mysql_fetch_array($result))
	{
		$username = $row['username'];
	}


}
?>

 

and then tried to test it by using

 

<div><?php echo $username ?></div>

 

but nothing is being echo'ed out. What am i doing wrong?

[TeNDoLLA]

You could test with simple echop inside your IF, if the mysql query actually returned something. Set or die(mysql_error()) after your query to see if it gives any errors. Also before echoing the $username variable you could do var_dump($username); to see if that variable has anything inside it.

[WebStyles]

does $_SESSION['MM_Username'] exist and have a value that exists in the database?

 

Your entire script will do exatly the same as this:

$username = $_SESSION['MM_Username'];

[hoponhiggo]

Dam. Another rookie mistake.

 

I could have just echo'd $_SESSION['MM_Username'] couldnt i? Silly me

[Adam]

While yes you could simply have echoed the session variable, you will later still need to retrieve the rest of the details for the user to see and edit. So you need to add the error / empty result set checks, and alter your query to return more of the columns.