if (mysqli_query($link,"INSERT INTO users SET user_login='".$login."', user_password='".$password."'")) {
header("Location: login.php");
exit;
} else {
var_dump(mysqli_error($link));
}
$password = md5(md5(trim($_POST['password'])));
, значит их клепал откровенный неуч, ничего не смыслящий в back-end. Срочно меняйте их на что-то более адекватное - иначе потом придётся долго и мучительно переучиваться. STR_TO_DATE('05-09-2019 17:02:14', '%d-%m-%Y %H:%i:%s')
"SELECT c.* FROM `" . MY_PREFIX . "_comments` AS c
INNER JOIN `" . MY_PREFIX . "_users` AS u ON c.user_id = u.id
WHERE c.text LIKE '%[url%' AND c.news_id != 77278 AND
u.rating < 500 AND u.stamp > DATE_SUB(NOW(), INTERVAL 1 YEAR)"
SELECT COUNT(pit.id) AS count, MAX(p.name) AS name
FROM Passenger AS p
LEFT JOIN Pass_in_trip AS pit ON p.id = pit.passenger
GROUP BY p.id
SELECT (SELECT COUNT(pit.id) FROM Pass_in_trip AS pit WHERE p.id = pit.passenger) AS count, p.name
FROM Passenger AS p
SELECT
order_id,
MAX(order_sum) AS d_sum
FROM table
GROUP BY order_id
HAVING COUNT(id) > 1
SELECT SUM(d_sum) AS a_sum
FROM (
SELECT
order_id,
MAX(order_sum) AS d_sum
FROM table
GROUP BY order_id
HAVING COUNT(id) > 1
) AS q
CREATE TRIGGER shoes_after_insert AFTER INSERT ON shoes FOR EACH ROW
UPDATE supplier SET all_shoes = all_shoes + 1 WHERE supplier_id = NEW.supplier;