You need to check the SQL syntax...
For Insertion (New row)
Code: Select all
INSERT INTO table ї(column1,column2...)] VALUES (value1,value2...);
so in your case it would be
Code: Select all
INSERT INTO registration (Confirm,Username) VALUES ('Yes','$UserName');
Updates are normally appended with a WHERE condition.
Code: Select all
UPDATE registration SET Confirm='Yes' WHERE Username='$UserName';
Next...
You have not shown how you connect to the database for processing. If not done then nothing will work anyway. You will need to go and look that up (try a web search for PHP MySQL if that is the database you are using).