CODEWITHSUNDEEP
phpmysqlsql
Paul Alexander Burkart
Paul Alexander Burkart

Reputation: 494

Query not executing. No errors

$query = "SELECT `ip` FROM `banned` WHERE `ip` = '$ip'";
$retval = mysqli_query($conn, $query);
if(!$retval){
    die("Could not Execute Query: " . mysqli_error($conn));
} else {
    if(mysqli_num_rows($retval) == 0){
        echo "test";
    } else {
        header('Location: http://www.teutonic-development.net/index.php?p=banned');
    }
}

when I'm running this code all that's printed out is: "Could not Execute Query:"

I really have absolutely no idea why it's doing this. I'm connecting fine in my init.php file. Which is where this file is.

My other script which just adds a log entry works fine. And if I run my $query in phpmyadmin's sql interpreter it runs perfectly fine (when I replace the $ip part with an actual ip of course)

Any suggestions?

Upvotes: 0

Views: 151

Answers (1)

Hanky Panky
Hanky Panky

Reputation: 46900

Normally one would say that hey your query failed to execute story finish. But this case is interesting.

Your code is

die("Could not Execute Query: " . mysqli_error($conn));

and your error message is

Could not Execute Query:

Notice even though you have mysqli_error($conn) but there is no mysql error being shown. That confirms 100% that $conn is not properly established (contrary to what you think)

So take a look at your code again and see if $conn is really a mysqli resource and is available to your file in proper variable scope.

Upvotes: 1

Related Questions