update php help

[juice]

i have a members login page that allows a member to login and view their details. I want to give the members an option to update their details as well, however it is not doing so.The viewdetails.php calls updatemembers.php to update member details and their session values. The following is the code for updatemember.php:

<?
session_start();
?>
<?
$username = $SESSION['username'];
$password = $SESSION['password'];
//$password2 = $SESSION['password'];
$fname = $SESSION['fname'];
$lname = $SESSION['lname'];
$street = $SESSION['street'];
$city = $SESSION['city'];
$county = $SESSION['county'];
$email = $_SESSION['email'];

include "db_connection.php";
$connect = db_connect();
if ($connect)
{
$query = "UPDATE member SET password = '" & $password & "', fname = '" & $fname & "', lname = '" & $lname & "', street = '" & $street & "', city = '" & $city & "' , county = '" & $county & "', email = '" & $email & "' WHERE username = '" & $username & "'"

//$result sets up theconnection query
$result = mysql_query($query,$connect);

if(mysql_num_rows($result))
{

$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
$_SESSION['fname'] = $fname;
$_SESSION['lname'] = $lname;
$_SESSION['street'] = $street;
$_SESSION['city'] = $city;
$_SESSION['county'] = $county;
$_SESSION['email'] = $email;

include success.php;
}
else
{
include "invaliddetails.html";

}

}
?>

I am getting the following error:

Parse error: parse error in c:\opensa\apache\htdocs\hbc\updatemember.php on line 22

[Huuggee]

$query = "UPDATE member SET password = '" & $password & "', fname = '" & $fname & "', lname = '" & $lname & "', street = '" & $street & "', city = '" & $city & "' , county = '" & $county & "', email = '" & $email & "' WHERE username = '" & $username & "'"

I your $query, & is not the concatenation operator the '.' is
If you replace all $ with . this should help

[thorpe]

lots of stuff going on here.

this line...

$result = mysql_query($query,$connect);

what do you expect $result to hold? youve used an UPDATE statement so its not going to retun any records. just true or false.

besides that... this code really doesnt do anything.

you take the users details from there session variables (which i will assume are set from the db when they log in) save them to local variables, update the database (with, if my above assumption is correct, the same data it already has) then you try to put these values back intoi the session variables there already in.

im only a newb and may be way off, but this is how i read your logic...

[thorpe]

I your $query, & is not the concatenation operator the '.' is

hehe....didnt even see that. must be another moving to php from asp.

[Huuggee]

lots of stuff going on here.

i was just looking at the line 22 error

[juice]

im trying to update the members personal info. that is update what is stored in the database and set the new update values to new sessions. For example when member updates his/her details and go back out and views their details, their personal details will show

tried replacing the & with . and still didnt work same error

$query = "UPDATE member SET password = '" . $password . "', fname = '" . $fname . "', lname = '" . $lname . "', street = '" . $street . "', city = '" . $city . "' , county = '" . $county . "', email = '" . $email . "' WHERE username = '" . $username . "'"

Is the above what you were saying for it?

Do ye get what in trying to do?

yes have come from asp background

[Huuggee]

$query = "UPDATE member SET password = '" & $password & "', fname = '" & $fname & "', lname = '" & $lname & "', street = '" & $street & "', city = '" & $city & "' , county = '" & $county & "', email = '" & $email & "' WHERE username = '" & $username & "'"

//$result sets up theconnection query
$result = mysql_query($query,$connect);

if(mysql_num_rows($result))
{

$_SESSION['username'] = $username;
$_SESSION['password'] = $password;
$_SESSION['fname'] = $fname;
$_SESSION['lname'] = $lname;
$_SESSION['street'] = $street;
$_SESSION['city'] = $city;
$_SESSION['county'] = $county;
$_SESSION['email'] = $email;

include success.php; 

$query is not terminated with ;

and that last include needs ' '

hope this helps

[juice]

yeah dat was a mistake leaving out the ' ' in the includes line. but i dont get by what you mean $query is not terminated by ;

[juice]

here is the code i have at the moment for the update:

<?
session_start();
include "db_connection.php";
$username = $SESSION['username'] ;
$password = $SESSION['password'];
$password2 = $SESSION['password'];
$fname = $SESSION['fname'];
$lname = $SESSION['lname'];
$street = $SESSION['street'] ;
$city = $SESSION['city'];
$county = $SESSION['county'];
$email = $_SESSION['email'];

$connect = db_connect();

$query = "UPDATE member SET password = '" & $password & "', fname = '" & $fname & "', lname = '" & $lname & "', street = '" & $street & "', city = '" & $city & "' , county = '" & $county & "', email = '" & $email & "' WHERE username = '" & $username & "'";
$SESSION['username'] = $username;
$SESSION['password'] = $password;
$SESSION['password'] = $password2;
$SESSION['fname'] = $fname;
$SESSION['lname'] = $lname;
$SESSION['street'] = $street;
$SESSION['city'] = $city;
$SESSION['county'] = $county;
$_SESSION['email'] = $email;

echo $_SESSION['fname'];

	mysql_close($connect);

?>

the problem is it is not updating the database. the echo just prints out the previous first name variable. so it is not updating the database or sessions
any help?