UPDATE not updating database

[tickled_pink]

I have the following code which should update a database with amended values edited by the user.

			//Update the pending table with any new values entered into the form by the admin
			$sql = "UPDATE pending SET business_name = $businessName,
									   address = $address,
									   district = $district,
									   town = $town,
									   county = $county,
									   postcode = $postcode,
									   telephone = $telephone,
									   fax = $fax,
									   email = $email,
									   contact = $contactName
					WHERE app_id = $application_id";
					//echo $sql;
					//exit;
			$result = mysql_query($sql);

The 'echo $sql' and 'exit' commands have been commented out. They are used to check the structure of '$sql' and do return the expected values.

But for some reason the database isn't updated with those values (in fact, the record isn't updated at all).

[seame]

Try putting $address (etc) between quotes, like:
address = '$address',
....

To improve debugging I also suggest adding somthing to you mysql_query, like:

$result = mysql_query($sql) or exit("<p style=\"font-family: Verdana, Arial, Helvetica, sans-serif; FONT-SIZE: 11px\"><b>MySQL says ($PHP_SELF):</b> <i>".mysql_errno().": ".mysql_error()."</i><br></p>");

good luck.

[tickled_pink]

Works great, thanks.