Not updating mysql :/

[ChrisMartino]

Ok so i have the code here were if the validation code in the database match's the one in the url it changes a number in the mysql but it doesn't?

 

This is the code were i change the number in the MySQL:

 

            	$URL = $_GET['account'];
                $URLVALIDATE = $_GET['validate'];
              if($URL == "confirm")
              {
              		$Stats = 1;
              		$UpdateUser = mysql_query("UPDATE `chrismar_xhost`.`Clients` SET `Status` = \'1\' WHERE `Clients`.`Validation` = '".$URLVALIDATE."'");
                    
                    if($UpdateUser)
                    {
                    	echo"<p>You're email address has been validated.</p>";
                    }
                    else
                    {
                    	echo"<p>There was a problem with the validation code.</p>";
                    }
              }

 

 

It just echo's there was a problem with the validation code? can anyone help?!? :[

[JAY6390]

Have you connected to the database?

 

Run

echo mysql_error();

after the query line, and see what that spits out

[ChrisMartino]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'1\' WHERE `Clients`.`Validation` = '3071'' at line 1

 

:/

[JAY6390]

Try this

 

$UpdateUser = mysql_query("UPDATE `chrismar_xhost`.`Clients` SET `Status` = '1' WHERE `Clients`.`Validation` = '".$URLVALIDATE."'");

[ChrisMartino]

Try this

 

$UpdateUser = mysql_query("UPDATE `chrismar_xhost`.`Clients` SET `Status` = '1' WHERE `Clients`.`Validation` = '".$URLVALIDATE."'");

 

Thanks worked brilliantly!, Many thanks!.