Session destroyed without any function, dont understand why it is this

imi_99

Hi,
I am stuck from yesterday with session problem. I got a car website, if user login then it saves some values in session like(user name, listing id, user type). But it get destroyed session when a user want to change his details like username password etc, here is the script when user login.
<?
session_start();
$user_name = isset($POST['login_user_name']) ? $POST['login_user_name'] : $SESSION['user_name'];
$user_pass = isset($POST['login_user_pass']) ? $POST['login_user_pass'] : $SESSION['user_pass'];

if((!isset($user_name)) || (!isset($user_pass)))
{
	return "login";
}

$_SESSION['user_name'] = $user_name;
$_SESSION['user_pass'] = $user_pass;

$query = "SELECT user_name, user_pass, user_type, user_fullname, user_id, listing_id FROM user_details WHERE user_name = '$user_name' AND user_pass = PASSWORD('$user_pass') AND user_type='5'";

$result = do_query($query, $dbcnx);
$row = mysql_fetch_array($result);
$user_name=$row['0'];
$user_fullname = $row['3'];

$_SESSION['user_name']=$user_name;

the whole script works ok. but if i want to change user_details and call this query again then session get destroyed. here is the query due to which session is getting destroyed.

$query="SELECT user_id, user_name, user_fullname, user_email, user_mobile, user_address, user_city, user_postcode FROM user_details
WHERE listing_id='$listing_id'";
$result=do_query($query, $dbcnx);

do any one knows why it is destroying session and how can i fix it. thanks in advance

samudasu

where are you coming up with the "do_query" function? $result = do_query($query, $dbcnx);

imi_99

samudasu wrote:
where are you coming up with the "do_query" function? $result = do_query($query, $dbcnx);

hi, i am calling this function do_query which is in include. file here is the function

which i call

function do_query($query, $dbcnx)
{
$result = mysql_query($query, $dbcnx);
if(!$result)
{
echo "<p>Error processing the sql query</p>";
echo $query;
exit();
}
return $result;
}

// $dbcnx = db_connect();
where $dbcnx is funtion called another function to connect with databse using username, password etc.
and this selects the database

this is tested and works ok. i got no problem with it. i always call this function if i do some query and making new connection with database.
The problem will somewhre around. if user have signed in and change his signed in user name/password then what is proper way to do it. or if user forgotton his username/passowrd etc. Is there any special way to do or this is just normal query like other mysql queries. I never done this before thats why asking. could get something better.