Pastie now auto-senses if line-wrap is a bad or good idea. Feedback?
## mark a section (Learn more)
$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.");
This paste will be private.
From the Design Piracy series on my blog: