$pass = md5($data['password']);
$username = $data['username'];
// sanitize the variables...
$pass = mysql_real_escape_string($pass, $iptriple);
$username = mysql_real_escape_string($username, $iptriple);
// update the AB account with the new password
$query = "UPDATE `ab_account` SET `password` = '". $pass . "' WHERE username = '" . $username ."'";
print $query;
// run the query
$result = mysql_query($query, $iptriple) or die("There was a problem with the mysql connection or query on line 571. \nPlease contact support about this issue.");
echo mysql_affected_rows();
// update the switch with the new password
$query = "UPDATE `orders` SET `column` = '" . $pass . "' WHERE (username) IN ('$username')";
// run the query
mysql_query($query, $switch) or die("There was a problem with the mysql connection or query. \nPlease contact support about this issue.");