Posted: Sun Oct 22, 2006 3:10 pm
echo $id and $ip
i'll bet you one of those isn't set
i'll bet you one of those isn't set
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<font color=white>
<?
$username= "muot_report";
$password= "report";
$database= "muot_report";
$connection = mysql_connect('localhost',$username,$password);
mysql_select_db($database);
$id = $_POST['id'];
$ip = $_POST['ip'];
$result = mysql_query("SELECT * FROM `comments` WHERE `ip` = '$ip'") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
if($ip == $row['ip'])
{
mysql_query("UPDATE `comments` set `show` = 0 WHERE `id` = $id") or die(mysql_error());
}
}
mysql_close($connection);
?>Code: Select all
<font color=white>
<?
$username= "muot_report";
$password= "report";
$database= "muot_report";
$connection = mysql_connect('localhost',$username,$password);
mysql_select_db($database);
$id = $_POST['id'];
$ip = $_POST['ip'];
mysql_query("UPDATE `comments` SET `show`=0 WHERE `ip`='$ip' AND `id`=$id") or die(mysql_error());
mysql_close($connection);
?>Code: Select all
<font color=white>
<?
$username= "muot_report";
$password= "report";
$database= "muot_report";
$connection = mysql_connect('localhost',$username,$password);
mysql_select_db($database);
$id = $_POST['id'];
$ip = $_POST['ip'];
echo "id: ".$id."<br>ip: ".$ip."<br>";
mysql_query("UPDATE `comments` SET `show`=0 WHERE `ip`='$ip' AND `id`=$id") or die(mysql_error());
mysql_close($connection);
?>Code: Select all
<font color=white>
<?
$id = $_POST['id'];
$ip = $_POST['ip'];
$username= "muot_report";
$password= "report";
$database= "muot_report";
$connection = mysql_connect('localhost',$username,$password);
mysql_select_db($database);
mysql_query("UPDATE `comments` SET `show`=0 WHERE `ip`='$ip' AND `id`=$id") or die(mysql_error());
mysql_close($connection);
?>Code: Select all
CREATE TABLE `comments` (
`id` int(99) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default '',
`comment` text NOT NULL,
`who` int(99) NOT NULL default '0',
`ip` varchar(50) NOT NULL default '0',
`show` int(2) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1040 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1040 ;