What's wrong with this SQL

Status
Not open for further replies.

Detox

Member
Jul 24, 2010
365
24
Is their something wrong with this SQL code?

PHP:
<?php
            $checkBan = mysql_query("SELECT `cms_comment_banned` FROM `users` WHERE `cms_comment_banned` = '1' AND `id` = '".$_SESSION['user']['id']."'");
            if (mysql_num_rows($checkBan) == 1)
            {
            ?>

Because it seems to work on localhost but not on my actual site
 

Zoxq

Member
Dec 13, 2013
62
14
Uhm, try changing it to this:
<?php
$checkBan = mysql_query("SELECT `cms_comment_banned` FROM `users` WHERE `cms_comment_banned` = '1' AND `id` = '".$_SESSION['user']['id']."'");
if (mysql_num_rows($checkBan) == 1) {
//Nothing to see here.
}
?>
 

Detox

Member
Jul 24, 2010
365
24
Uhm, try changing it to this:
<?php
$checkBan = mysql_query("SELECT `cms_comment_banned` FROM `users` WHERE `cms_comment_banned` = '1' AND `id` = '".$_SESSION['user']['id']."'");
if (mysql_num_rows($checkBan) == 1) {
//Nothing to see here.
}
?>
That worked

EDIT:
So now this code is breaking my page!

PHP:
<?php
            }
            else {
                $getArticle = mysql_query("SELECT * FROM `cms_news` WHERE `id` = '".filter($_GET['id'])."'") or die(mysql_error());
                if (mysql_num_rows($getArticle) > 0)
                {
                    $articleInfo = mysql_fetch_array($getArticle) or die(mysql_error());
                    if(isset($_POST['post_comment']) && $_SESSION['user']['id'] != null)
                    {
                        $checkBan = mysql_query("SELECT `cms_comment_banned` FROM `users` WHERE `cms_comment_banned` = '1' AND `id` = '".$_SESSION['user']['id']."'");
                        if (mysql_num_rows($checkBan) == 0)
                        {
                            if($_POST['comment'] == NULL)
                                $errorMessage = 'You have left a field empty.';
                            else
                            {
                                $checkInfo = mysql_query("SELECT * FROM `cms_comments` WHERE `article` = '".filter($_GET['id'])."' ORDER BY `id` DESC LIMIT 1") or die(mysql_error());
                                $newsInfo = mysql_fetch_array($checkInfo);
                                if($newsInfo['userid'] == $_SESSION['user']['id'])
                                    $errorMessage = 'Hey! The last comment was from you, let somebody else comment first!';
                                else
                                {
                                    mysql_query("INSERT INTO `cms_comments` (`article`, `userid`, `comment`, `posted_on`) VALUES ('".filter($_GET['id'])."', '".$_SESSION['user']['id']."', '".filter($_POST['comment'])."', '".date("M j, Y g:i A")."')") or die(mysql_error());
                                    $successMessage = 'You have successfully left a comment.';
                                }
                            }
                        }
                    }
                ?>
 
Status
Not open for further replies.

Users who are viewing this thread

Top