update table command with php script

[Banana Man]

Hey,

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.

Thanks

		$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)
			or die(mysql_error());

[r937]

you aren't checking your mysql errors, are you

try copy/paste that query directly into a mysql front end utility or your mysql command line

tip: if you have problems getting a mysql query running in php, make sure you test it in mysql first

[swampBoogie]

$sql = "UPDATE apple_users
		SET private_group = 10,
		private_group_name = 'skerries',
		private_group_password = 'klsokp'
		WHERE ".$_SESSION['user_id']." = user_id
		";

[longneck]

awwww.... sb- you're no fun! rudy and i love to torture people who don't error-check their queries outside the host language!