SQL Update Statement in PHP failing

[Robert Binns]

Hello,
I have been working on an extremely basic update query to a mysql
database, and cannot seem to stop getting errors. Here is my source
(minus the connection):

$query = 'UPDATE inventory SET imagename = \'' . $_POST['imagename'] .
'\', category = \'' . $_POST['category'] . '\', location = \'' .
$_POST['location'] . '\', comments = \'' . $_POST['comments'] .'\'
WHERE imageid = \'' . $_GET['id'] . '\'';

print($query);

$result = mysql_query($query, $link) or die("Query failed : " .
mysql_error());

if($result)
{
print('Update Successful!');
}

mysql_free_result($result);
mysql_close($link);
And the browser sees this:

UPDATE inventory SET imagename = 'slo', category = 'Ball Python',
location = 'slo', comments = 'foo' WHERE imageid = '3'Query failed :

Any Ideas? Thanks in advance for your response.

R. Binns

[Jay Donnell]

copy and past the query into mysql and see what it says.