MySQL UPDATE not doing anything?? Help

Anon

I'm trying to update the records in a table. I have full access to the database and table that I'm trying to update, but when I try to perform the update it never updates the table. It doesn't return an error, it just doesn't update. Here's a sample of my code (I replaced the username and password for security purposes and $sysid is an array of values, the 1 value is the primary key value for that particular table and my lookup for the update):

<?php
mysql_connect("localhost","someuser","somepassword");
mysql_select_db("esm");

if(isset($HTTP_POST_VARS['Submit'])){
	$stext = $_POST['sysnotes'];

	$sql = "UPDATE systeminfo SET systemnotes = $stext WHERE sysid = '".$sysid[1]."'";
	$result = mysql_query($sql);

}
?>

It's really wierd. I don't get any kind of an error, but it doesn't work.
I've positioned this code in the <head> element since once I get it working I will need to add some meta tags.

kbdrand

Nevermind, I found the problem. Turns out the SQL statement was failing due to no single quotes around the $stext variable.

Anon

Try like this:
$sql = "UPDATE systeminfo SET systemnotes = '$stext' WHERE sysid = '".$sysid[1]."'";

That means put $stext in single quotation

Anon

You didn't see any error because you didn't check for one:

http://www.mysql.com/doc/m/y/mysql_error.html

I suspect the problem is that you need quotes around $stext in the query.