[RESOLVED] At witt's end when Updating..

[IceRegent]

ok, I am needing help. I cannot see where my error is in my code. WHen I use the "INSERT" statement on my php with the supplied values, the query works wonderful. But now, I need to change it to an "UPDATE". AT fiirst I was getting error messages, but I worked thru them, and now, I get no error messages, but I have no updated changes either. Here is the code I am working with:

<?php
include "db_config.php";
mysql_select_db(iceregen_MStudio);
$Locate1 = $_POST['Locate'];
$NewsItem1 = $_POST['NewsItem'];
echo $Locate1;
echo $NewsItem1;

$query = "UPDATE news SET Content=$NewsItem1 WHERE Location=$Locate1";
//$query="INSERT INTO `news` (`NewsID`, `Location`, `Content`) VALUES ('', '$Locate1', '$NewsItem1');";
$result=mysql_query($query); 

The Insert query that is commented out, worked, but my update query wont. What am I doing wrong? No error messages to tell me anything doesnt help.

Thanks
Ice

[laserlight]

You forgot to quote your values.

[IceRegent]

Thank you laserlight, for pointing out what my eyes couldnt see. Sometimes you get so buried in the code that you cannnot see the little thing that you missed that's holding up your whole process. I modified it like thus:

$query = "UPDATE news SET Content='$NewsItem1' WHERE Location='$Locate1'";
//$query="INSERT INTO `news` (`NewsID`, `Location`, `Content`) VALUES ('', '$Locate1', '$NewsItem1');";
$result=mysql_query($query);

And it worked wonders!

Thanks again;
Ice