Updating information

[ShilohWarrior]

I was wondering what action i would use to update information in mysql database using php. I tried this but it did not work:

Code:

<?php

   $Server="";            
   $DBuser="";               
   $DBpass="";
   $Database ="";
   $Table="";
   
//Here are all the variables flash is sending to php.

   $username = stripslashes($_POST[username]);
   $password = stripslashes($_POST[password]);
   $name = stripslashes($_POST[name]);
   $email = stripslashes($_POST[email]);
   $location = stripslashes($_POST[location]);
   $websitetitle = stripslashes($_POST[websitetitle]);
   $websiteurl = stripslashes($_POST[websiteurl]);
   $personaltext = stripslashes($_POST[personaltext]);
   $pic = stripslashes($_POST[pic]);
   $ownpic = stripslashes($_POST[ownpic]);
   $ownpiccheck = stripslashes($_POST[ownpiccheck]);

   $DBconnect = mysql_connect($Server, $DBuser, $DBpass); 

   mysql_select_db($Database,$DBconnect);

   $Send="UPDATE INTO $Table (username, password, name, email, location, websitetitle, websiteurl, personaltext, pic, ownpic, ownpiccheck) VALUES('$username', '$password', '$name', '$email', '$location', '$websitetitle', '$websiteurl', '$personaltext', '$pic', '$ownpic', '$ownpiccheck') WHERE username = '$username'";
   mysql_query($Send,$DBconnect);

   mysql_close ($DBconnect);

   print "&Status=Update Complete. Your information has been Updated.";
?>

It wont update it. Whats wrong? Am i doing the UPDATE INTO right?

[Musicman]

Hi,

there is an INSERT INTO table which adds a new entry to your database (new submission) and there is an UPDATE table SET varname = 'value' to submit any changes to an existing record

Musicman

[ShilohWarrior]

ahhh ok thanks i wasnt sure how to update it and set it. Thanks musicman