Date: 11/12/07 (Code WTF)    Keywords: php, sql, web

Пожаловались мне в аську давеча на чужой код...

$sql = "UPDATE " . USERS_TABLE . "SET  . $username_sql . $passwd_sql . "
user_email = '" . str_replace("\'", "''", $email) . "', 
user_icq = '" . str_replace("\'", "''", $icq) . "', 
user_website = '" . str_replace("\'", "''", $website) . "', 
user_occ = '". str_replace("\'", "''", $occupation) . "', 
user_from = '" . str_replace("\'", "''", $location) . "', 
user_interests = '" . str_replace("\'", "''", $interests) . "', 
user_sig = '" . str_replace("\'", "''", $signature) . "', 
user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', 
...
WHERE user_id = $user_id";

Source: http://community.livejournal.com/code_wtf/112766.html