Im trying to do a mysql update table command through a php script but im having problems. The first column to be updated is an "INT" column and this updates fine but the other two columns are "VARCHAR" columns. Is their something i have to do differently to update a VARCHAR field or something???
When i try this code it updates "private_group" to the new value (10) but just leaves the other two fields blank in the mysql table.
$sql = "UPDATE apple_users
SET private_group = 10,
private_group_name = skerries,
private_group_password = klsokp
WHERE ".$_SESSION['user_id']." = user_id
$results = mysql_query($sql)