Query Problem

[Tom10]

Hi, i am sending a query to my database, to check if my website is under maintainance, it's ment to display an access denied page if maintainance in the table is equal to 1 but it's not working properly.

 

Here is the code: 

<?php

error_reporting(E_ALL | E_NOTICE);

require 'connect.php';

session_start();

$pageMaintain = "SELECT maintainance FROM config";

$result = mysqli_query($con, $pageMaintain);

if(mysqli_num_rows($result) == 1) {

include 'accessdenied.php';

die();

} else {



}

?>

And a picture of the table: 

It doesn't matter if it's 0 or 1 it still includes the access denied page.

Edited February 20, 2015 by Tom10

[cyberRobot]

Have you tried adding a WHERE clause? Basically, you only want the query to return a row if the maintenance column is set to 1. Maybe something like this:

 

$pageMaintain = "SELECT maintainance FROM config WHERE maintainance=1";

[Tom10]

 

Have you tried adding a WHERE clause? Basically, you only want the query to return a row if the maintenance column is set to 1. Maybe something like this:

$pageMaintain = "SELECT maintainance FROM config WHERE maintainance=1";

Thank you!, It worked

[cyberRobot]

Thank you!, It worked

 

No problem, glad to help!