doesnt update its database

[adchico]

this is my code

 

$query = mysql_query("UPDATE registration SET Fname = '$fname' AND MI = '$MI' AND Lname ='$Lname' WHERE username= '$user'");

 

echo $query;

 

if($query){

echo "Thank you $user, your record has been updated sucessfully! <a href= 'index.php?section=User_account'> Back </a>" ;

 

}else{

echo "There has been an error.

".mysql_error();

}

 

 

 

Output is ok:

1

Thank you Mario, your record has been updated sucessfully! BACK

 

but when you look in the database it is not really updated!

 

[anujgarg]

it seems that no value is coming in your $user variable...try to print the query and check if it shows the desired values

[adchico]

I already echoed out the result of the query it opted

 

1

 

what does it mean?

[anujgarg]

have you printed out the whole query? I mean to say just put 'echo' in front of your query statement and have a look at it in the browser and then execute that query into MySQL

[darkfreaks]

$query = mysql_query
("UPDATE registration SET Fname = $fname AND MI = $MIAND Lname =$Lname
WHERE username= $user");

 

 

that should work the single quotes are messing it up since it is already parsed in double quotes