Help me please. On the server detects an error. Here she is:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in z:\home\synape\www\testreg.php on line 27 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in z:\home\synape\www\testreg.php on line 45 Извините, введённый вами логин или пароль неверный."
Here is half the code:
include ("bd.php"); $ip=getenv("HTTP_X_FORWARDED_FOR"); if (empty($ip) || $ip=='unknown') { $ip=getenv("REMOTE_ADDR"); } mysql_query ("DELETE FROM oshibka WHERE UNIX_TIMESTAMP() - UNIX_TIMESTAMP(date) > 900"); $result = mysql_query("SELECT col FROM oshibka WHERE ip='$ip'",$db); $myrow = mysql_fetch_array($result); if ($myrow['col'] > 2) { exit ("Вы набрали логин или пароль неверно 3 раза. Подождите 15 минут до следующей попытки."); } $password = md5($password); $password = strrev($password); $password = $password."b3p6f"; $result = mysql_query("SELECT * FROM users WHERE login='$login' AND password='$password'",$db); $myrow = mysql_fetch_array($result); if (empty($myrow['id'])) { $select = mysql_query ("SELECT ip FROM oshibka WHERE ip='$ip'"); $tmp = mysql_fetch_row ($select); if ($ip == $tmp[0]) { $result52 = mysql_query("SELECT col FROM oshibka WHERE ip='$ip'",$db); $myrow52 = mysql_fetch_array($result52); $col = $myrow52[0] + 1; mysql_query ("UPDATE oshibka SET col=$col,date=NOW() WHERE ip='$ip'"); }
And the error in the code is here:
$myrow= mysql_fetch_array($result);
and $tmp= mysql_fetch_row($select);