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*'"; } ?>

Your Answer:

Login to answer

Other forums

 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 
Looking for help on using joining mysql tables and php.... 
Does anyone have any good links to references on how to pull mysql data, through joining tables and 
Comparing MySql data and arrays. 
I have a mysql table set up like this:
idsubjectbodyuseriddatetimetags1blog subjectblog body111|2
Need some ideas as to how to go about sorting this array... 
Here's how the array's are created..

Code: <?php
while ($x = readdir($dp)) {
   
Fetching array then reversing it 
Hi, I have a simple problem, I'll try to explain it as best I can:
News entries in my database ar
php problem? 
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put 
Adding post count 
How would I make it so everytime someone clicks submit on my form, their row in the database for the
New to Arrays 
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan
Echoing If Function? 
A script I am using has If statements in the comments form to basically tell the form what to do. Cu
help retrieiving results and doing pagination  
Having some trouble trying to get the results to show on more than just one page. 

What is ha