MySQL query in PHP

Roble

What is wrong with this? It's not updating the stuff in my table...

<html>
<form name="update_stats" method="post" action="update_stats.php">
<b>Stats<br>Username:</b> </html><?php echo $user_name ?> <html> ->
<input type="text" name="user_name_update"><br>
<b>Main job:</b> </html><?php echo $main_job ?><html> ->
<input type="text" name="main_job_update"><br>
<b>Support job:</b> </html><?php echo $support_job ?><html> ->
<input type="text" name="support_job_update"><br>
<b>Advanced job:</b> </html><?php echo $advanced_job ?><html> ->
<input type="text" name="advanced_job_update"><br>
<b>Rank:</b> </html><?php $rank ?><html> -> </html>
<?php echo $rank ?> <html><br>
<b>Email:</b> </html><?php echo $email ?><html> ->
<input type="text" name="email_update"><br>
<b>AIM:</b> </html><?php echo $AIM ?><html> ->
<input type="text" name="AIM_update"><br>
<input type="submit" value="submit">
</form>
</html>

<?php

// Get the user's input from the form
$user_name_update = $POST['user_name_update'];
$main_job_update = $POST['main_job_update'];
$support_job_update = $POST['support_job_update'];
$advanced_job_update = $POST['advanced_job_update'];
$email_update = $POST['email_update'];
$AIM_update = $POST['AIM_update'];

// Register session key with the value
$SESSION['user_name_update'] = $user_name_update;
$SESSION['main_job_update'] = $main_job_update;
$SESSION['support_job_update'] = $support_job_update;
$SESSION['advanced_job_update'] = $advanced_job_update;
$SESSION['email_update'] = $email_update;
$SESSION['AIM_update'] = $AIM_update;
if ($main_job_update OR $support_job_update OR $advanced_job_update OR $email_update OR $AIM_update !='') {
	$query = "UPDATE member_area SET user='$user_name_update' AND main_job='$main_job_update' AND support_job='$support_job_update' AND advanced_job='$advanced_job_update' AND email='$email_update' AND AIM='$AIM_update' WHERE user='$user_name'";
}
} else {
	print 'Not valid. Please login.';
?>

<html>
<form name="login" method="post" action="update_stats.php">
username:<input type="text" name="user_name"><br>
password:<input type="password" name="password"><br>
<input type="submit" value="submit">
</form>
</html>

<?php
$user_name = $POST['user_name'];
$password = $POST['password'];
}
?>

Also, how do include another php file, and call the variables within it only when they are needed?

barand

Your update query should have commas in place of those AND's

$query = "UPDATE member_area 
SET user='$user_name_update' , 
main_job='$main_job_update' , support_job='$support_job_update' , 
advanced_job='$advanced_job_update' , 
email='$email_update' , 
AIM='$AIM_update' 
WHERE user='$user_name'";