using UPDATE on a test server

findhorn wrote:
> I wondered if the mysql_query function needed a reference to
> the database?

No, mysql_query() just needs the query. Your problem lies with quotes in
the query itself. A couple of the values are not in quotes. There should
also not be a comma before WHERE.

$query_updateAvailability = "UPDATE tbl_availability
SET satStatus='".mysql_real_escape_string($_POST['satStatus'])."',
sunStatus='".mysql_real_escape_string($_POST['sunStatus'])."'
WHERE
availabilityId='".mysql_real_escape_string($_POST['availabilityId'])."'";


--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/