Am trying to update my dataase with the script below but its pointing out a problem near add='$add' and i couldnt see it. please help if you can.


<?

if ($_COOKIE['user']){

$cook=$_COOKIE['user'];
$pwd=$_POST['pwd'];
$rname=$_POST['rname'];
$email=$_POST['email'];
$add=addslashes($_POST['add']);
$city=$_POST['city'];
$state=$_POST['state'];
$country=addslashes($_POST['country']);
$interest=$_POST['interest'];

$sql=mysql_query("update youth set pwd='$pwd',email='$email',rname='$rname',add='$add ',city='$city',state='$state',county='$country',in terest='$interest' where uname='$cook' ");




if ($sql){

echo " Info Updated successfully";

}else { echo mysql_error();}

}else{echo " Not logged in";}
?>

what is the structure of the db and what kind of data do you have in $add ?

county='$country'

^should they both be 'county' or is that just a typo in your post?

Not typo, its the column name. But the variable is $country.

The type for add is var(255).