Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
Mpaka каза:как проверя дали има 2 потребители регнати с 1 и също ИП.
Имам таблица `users` -> signup_ip
$sql = mysql_query("SELECT signup_ip FROM users WHERE signup_ip='$ip' LIMIT 1 ");
if(mysql_num_rows($sql) == 1)
{
echo "ima veche takova ip";
}
else
{
echo "nqma takuv user s tova ip";
}
Пак не виждам за моя случайF1r3Fl3x каза:Виж тук -> http://lists.mysql.com/mysql/201847![]()
<?
require_once('includes/config.inc.php');
$sql = mysql_query("SELECT COUNT(*) as id FROM users WHERE ip = '62.178.45.*'") or die(mysql_error());
echo '<p>-------------------------------------------------------</p>';
$sql = mysql_query("SELECT * FROM users WHERE ip = '62.178.45.*'") or die(mysql_error());
?>
Just group them together:
mysql> create table a(a int, b text);
Query OK, 0 rows affected (0.05 sec)
mysql> insert into a(a, b) values (1, 'google.com');
Query OK, 1 row affected (0.00 sec)
mysql> insert into a(a, b) values (1, 'google.com');
Query OK, 1 row affected (0.00 sec)
mysql> insert into a(a, b) values (2, 'google.com');
Query OK, 1 row affected (0.00 sec)
mysql> insert into a(a, b) values (2, 'yahoo.com');
Query OK, 1 row affected (0.00 sec)
mysql> insert into a(a, b) values (3, 'yahoo.com');
Query OK, 1 row affected (0.00 sec)
mysql> select count(*) as num, a, b from a group by b,a having count(*) > 1;
+-----+------+------------+
| num | a | b |
+-----+------+------------+
| 2 | 1 | google.com |
+-----+------+------------+
1 row in set (0.00 sec)
$sql = mysql_query("SELECT signup_ip FROM users WHERE signup_ip='62.178.45.*' LIMIT 1 ");
if(mysql_num_rows($sql) == 1)
{
echo "ima veche takova ip";
}
else
{
echo "nqma takuv user s tova ip";
}
?>