[Resolved] need help with MySQL UPDATE syntax, I think

[jacksonpt]

Why won't this update the record? I tried serveral different variations of this code with no luck (putting the variables in ' ', in " ", etc.). Or could my problem be elsewhere? I'm 99.9% sure the WHERE FirstName='$FirstName' works because I use the same code later on in the script.

     

$db = mysql_connect("localhost", "root");
mysql_select_db("4rocmembers",$db);
$result = mysql_query("UPDATE members
                                      SET City='$City', 
		             Email='$Email', 
		             Website='$Website' 
		      WHERE FirstName='$FirstName'",$db);
echo "<BR><BR><center>Thank you!<br>Information updated.</center>\n";

Sorry about the formatting... I can't seem to get it intented properly in the post.

[LordShryku]

Debug

$db = mysql_connect("localhost", "root"); 
mysql_select_db("4rocmembers",$db); 
$sql = "UPDATE members 
        SET    City='".$City."', 
               Email='".$Email."', 
               Website='".$Website."' 
        WHERE  FirstName='".$FirstName."'";
echo $sql."<br /><br />";
$result = mysql_query($sql) or die(mysql_error());

[jacksonpt]

I got it... my problem was elsewhere in the code.

Thanks for the debug tip... me thinks that'll come in handy.