Write Forums

Comment Mod System Effects all rows...

Posted on 16th Feb 2014 07:03 pm by admin

Sorry if its confusing but here is whats going on: I have a table in a database called comments and there are alot of entries there but can manually be marked flagged with a 1. nevermind how that is done, but I made it so the comments are printed on a pass protected page with two links below them. Ignore is supposed to mark that comment with a 0, and delete deletes the row.

Everything works fine but the action happens to ALL the comments that are shown. Can anyone see why that is happening?

Code: <?
if($session->isAdmin()){?>
<center><font face="Papyrus" size="5">MOD Center</font></center>
<center><a href='mod1.php'>[News Aproval]</a> <a href='mod2.php'>[Flagged Items]</a></center>
<?$con = mysql_connect("localhost","bmvybfbk_master","74SAc194G");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("bmvybfbk_website", $con);

$result = mysql_query("SELECT * FROM comments WHERE flagged = '1'");

while($row = mysql_fetch_array($result))

{
$cnumber = $row['id'];
echo $row['writer'] . " wrote:
" . $row['comment'];
echo "
<a href='mod2.php?action=ignore'>[Ignore]</a>";
echo " <a href='mod2.php?action=delcomment'>[Delete]</a>";
echo "
----------------------------------------------------------------------------------------------------
";


if ($action == ignore) {
mysql_query("UPDATE comments SET flagged = '0' WHERE id = '$cnumber' LIMIT 1");}

if ($action == delcomment) {mysql_query("DELETE FROM comments WHERE id='$cnumber' LIMIT1");}

else {echo " ";}

}
}else{ echo "*You Don't Have any rights to View this page*'"; } ?>

No comments posted yet

114 8 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
onclick problem 
I have <input type="text" name="message">
<a href=page2.
How to schedule the a job?   
Hi,

     I have prepared a task ( i.e. a procedure is prepare the file and send the same to con
Running External Scripts 
I am very new to PHP and am not even sure what I'm asking is possible.  I have just installed mediaW
Required to login help 
I'm trying to set up my site so users have to be logged into the forum to access the site.I've been 
Reduce redundancies in switch functions? 
Hello all!  I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit
[PHP HELP] Php order form. 
Hello to everyone @ phpfreaks. Im new to this site and hope to learn lots of things here.

Fir
losing session vars when arriving from an email link 
Hi,

I've got a confirmation script made that sends an email with a link for a user to confirm
article site help remaining text 
Hi all hope you will be fine
I am creating a article site in this site i want to put some text on