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?
Did you know? Explore Trending and Topic pages for more stories like this.
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
Your Answer:
Login to answer
114 8
Other forums code help - pagination Hi all, I have this code, basically a user logs into my site and they get this page. The pro
Shuffle Array Hi, I am writing a script for a game that needs players to randomly be assigned a target (ano
$_POST Hi, I have 2 seperate php files, and i want my $_POSt["fname"] To go into both of them, Fo
multipart emiail forms Hi All, I am new to the boards and I've been working on a form (which is rather massive, imo
Onclick problem in Firefox Hi, I am using a . It doesn't seem to
value not going in data base hello friends.... i am having a working javascript....when i am selecting any
Need help in Generating Combinations Need help generating all possible combination of names in an array Lets say i have the follow
PHP Code / Script To check weather the given email exists in a domain Hi, I want to implement the following in my web page in sign up we will ask to enter u
Retrieving innerHTML with cURL? Hey all (sorry I know I'm a leecher, but I soon won't be. This is my first PHP project, but not my l
Multi language - seo links Im trying to figure out the best method to have a multi language website that will function with seo