Can't figure it out.

[ATLien]

$id = $HTTP_SESSION_VARS['valid_user'];

$all_data = mysql_query("Select * from sv_colleges as c, sv_users as u where c.college_id=u.user_school && u.user_id='$id'") or die ("Mysql error: " . mysql_error());
$result = mysql_fetch_array($all_data);

I then echo the values like so.

<?PHP echo $result['user_name']; ?>

That is a SQL statment that I use to retrieve data from 2 MySQL Table. It works fine the first time, but if I refresh the page all the values that where appearing disapear. Is this a seesion problem or what? I have not idea what is causing it. I use sessions and the values in the SESSIONS_VARS still appear but everything form the sql_query above disappears. The only way to make the values reappear is to dump the tables. Please help. I am so lost.

[tomhath]

What do you mean by "dump the tables" to make the values reappear?

Does this page do anything else to the database besides this one select?

[ATLien]

Originally posted by tomhath
What do you mean by "dump the tables" to make the values reappear?

Does this page do anything else to the database besides this one select?

I mean when I delete all the table values then fill in again they will appear once on the page again.

[ATLien]

I tracked the problem down to my handler. Tell me if I am going about this the right way. It is for a profile page where peoples data will show in a form then when they submit the form it goes here. This checks to see if the values different between the posted values and the database values. Is this the best way to do a update profile page?

$all_data = mysql_query("Select * from sv_colleges as c, sv_users as u where c.college_id=u.user_school && u.user_id='$valid_user'") or die ("Mysql error: " . mysql_error());
$result = mysql_fetch_array($all_data);

$password = $HTTP_POST_VARS['password'];
$pass2 = $HTTP_POST_VARS['pass2'];
$email = $HTTP_POST_VARS['email'];
$age = $HTTP_POST_VARS['age'];
$aim = $HTTP_POST_VARS['aim'];
$yahoo = $HTTP_POST_VARS['yahoo'];
$msn = $HTTP_POST_VARS['msn'];
$icq = $HTTP_POST_VARS['icq'];
$state = $HTTP_POST_VARS['state'];
$city = $HTTP_POST_VARS['city'];
$hours = $HTTP_POST_VARS['hours'];
$other = $HTTP_POST_VARS['other'];
$live = $HTTP_POST_VARS['live'];
$schoolav = $HTTP_POST_VARS['schoolav'];
$avatar = $HTTP_POST_VARS['avatar'];
$displaycontact = $HTTP_POST_VARS['displaycontact'];
$title = $HTTP_POST_VARS['title'];
$signature = $HTTP_POST_VARS['signature'];
$rated = $HTTP_POST_VARS['rated'];
$image = $HTTP_POST_VARS['image'];
$resetvotes = $HTTP_POST_VARS['resetvotes'];

if (isset($password) && isset($pass2))
{
	if ($password != $pass2){
	      echo 'The passwords you entered do not match - please go back - You only need to fill in the password sections if you are changing your password'
	           .' and try again.';
	}

if (strlen($pass)<4 || strlen($pass) >16){
   echo 'Your password must be between 4 and 16 characters.' 
        .'Please go back and try again.';
}

$password = md5($password);

$sql = mysql_query("UPDATE sv_users SET user_password = '$password' WHERE user_id = '$id'");
}

if ($email <> $result['user_email'])
{
	if (!valid_email($email)){
		echo 'The Email You Entered Does Not Appear To Be a Valid Email'
			.'Please Go Back and Enter It Again.';
	}

	$sql = mysql_query("UPDATE sv_users SET user_email = '$email' WHERE user_id = '$id'");
}

if ($age != $result['user_age'])
{
		$sql = mysql_query("UPDATE sv_users SET user_age = '$age' WHERE user_id = '$id'");
}

if ($displaycontact != $result['user_displaycontact'])
{
		$sql = mysql_query("UPDATE sv_users SET user_displaycontact = '$displaycontact' WHERE user_id = '$id'");
}

if ($title != $result['user_title'])
{
		$sql = mysql_query("UPDATE sv_users SET user_title = '$title' WHERE user_id = '$id'");
}

if ($schoolav = yes)
{
		$schoolav = $result['college_avatar'];
		$sql = mysql_query("UPDATE sv_users SET user_avatar = '$schoolav' WHERE user_id = '$id'");
}

if (isset($avatar))
{
		$sql = mysql_query("UPDATE sv_users SET user_avatar = '$avatar' WHERE user_id = '$id'");
}

if (isset($image))
{
		$sql = mysql_query("UPDATE sv_users SET user_image = '$image' WHERE user_id = '$id'");
}

if ($resetvotes = yes)
{
		$sql = mysql_query("UPDATE sv_users SET user_votes = '0', user_votecount = '0' WHERE user_id = '$id'");
}
else
{
	echo 'No Changes Where Made To Your Profile';
}


}

I deleted some repeating if statments to save space. Please help me out.