Проблем с даване на точка

freboy

Registered
Защо не дава точка плс оправете го

<?php
include "config.php";
$id = $_GET['id'];
$ip = $_SERVER["REMOTE_ADDR"];
$query1 = "SELECT * FROM ip WHERE ip='$ip' AND name_id='$id'";
$result1=mysql_query($query1);
if (mysql_num_rows($result1)>0)
{
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
$row=mysql_fetch_array($result);
$id=$row[id];
$name=$row[name];
$points=$row[points];
$points2= $points+ 1;
$time = time() +1;
$sql3 ="INSERT INTO `ip`(`id`, `name_id`, `ip`,`time`) VALUES ('', '".$id."', '".$ip."', '".$time."' )";
$do = mysql_query($q) or die(mysql_error());



if(mysql_query($sql3) != "")
{
$sql="UPDATE users SET points='$points2' where id='$id';";
if(mysql_query($sql) != "")
{
echo "Вие дадохте точка на $name<br>";
}else
{
echo "MySQL";
}
}
}
?>
 
<?php
include "config.php";
$id = $_GET['id'];
$ip = $_SERVER["REMOTE_ADDR"];
$query1 = "SELECT * FROM ip WHERE ip='$ip' AND name_id='$id'";
$result1=mysql_query($query1);
if (mysql_num_rows($result1)>0)
{
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
$row=mysql_fetch_array($result);
$id=$row['id'];
$name=$row['name'];
$points=$row['points'];
$points2= $points+ 1;
$time = time() +1;
$sql3 ="INSERT INTO `ip`(`id`, `name_id`, `ip`,`time`) VALUES ('', '$id', '$ip', '$time' )";
$do = mysql_query($q) or die(mysql_error());



if(mysql_query($sql3) != "")
{
$sql="UPDATE users SET points='$points2' where id='$id';";
if(mysql_query($sql) != "")
{
echo "Вие дадохте точка на $name<br>";
}else
{
echo "MySQL";
}
}
}
?>
Така?
 
Код:
<?php
include "config.php";
$id = $_GET['id'];
$ip = $_SERVER["REMOTE_ADDR"];
$query1 = "SELECT * FROM ip WHERE ip='$ip' AND name_id='$id'";
$result1=mysql_query($query1);
if (mysql_num_rows($result1)>0)
{
$query = "SELECT * FROM users WHERE id='$id'";
$result = mysql_query($query);
$row=mysql_fetch_array($result);
$id=$row['id'];
$name=$row['name'];
$points=$row['points'];
$points2= $points+ 1;
$time = time() +1;
$sql3 ="INSERT INTO `ip`(`id`, `name_id`, `ip`,`time`) VALUES ('', '$id', '$ip', '$time' )";
$do = mysql_query($q) or die(mysql_error());



if(mysql_query($sql3) !== "")
{
$sql="UPDATE users SET points='$points2' where id='$id';";
if(mysql_query($sql) !== "")
{
echo "Вие дадохте точка на $name<br>";
}else
{
echo "MySQL";
}
}
}
?>
 

Back
Горе