Untitled

<html>
<?PHP

//Database Information

$dbhost = "localhost";
$dbname = "quicksco_leader";
$dbuser = "quicksco_hitch";
$dbpass = "123abc";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());


$currentpass = $_POST['currentpassword'];
$newpass = $_POST['newpassword'];
$clanname = $_POST['clanname'];


// lets check to see if the username already exists

$checkpassword = mysql_query("SELECT username FROM users WHERE password='$currentpass'");

$currentpass_exist = mysql_num_rows($checkpass);

if($currentpass_exist > 0){

// lf no errors present with the username
// use a query to insert the data into the database.

$query = "INSERT INTO users (password, Clan name)
VALUES('$newpass', '$clanname')";
mysql_query($query) or die(mysql_error());
mysql_close();

echo "Information has been updated.";


?>