why datatable count all entries, look at this codes

[mahenda]

//please dont talk about sql injection, i'll work on it, the problem with this code, it count all entries in a database table but i wantto count only with nid = 1
$query = 'SELECT * FROM abc WHERE nid = 
if(!empty($_POST["search"]["value"])){
$query .= 'AND (a LIKE "%'.$_POST["search"]["value"].'%" 
OR b LIKE "%'.$_POST["search"]["value"].'%" 
OR c LIKE "%'.$_POST["search"]["value"].'%") ';      
} 
if(!empty($_POST["order"])){
            $query .= 'ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
        } else {
            $query .= 'ORDER BY id DESC ';
        }
        if($_POST["length"] != -1){
            $query .= 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length'];
        }   
        $result = mysqli_query(dbConnect, $query);

 

[Barand]

First thing you should do is turn on error reporting and clear all your syntax errors. Then you can worry about getting the query right.

[mahenda]

23 minutes ago, Barand said:

First thing you should do is turn on error reporting and clear all your syntax errors. Then you can worry about getting the query right.

 

AWESOME SOLUTION THANKS, SOLVED, IT WAS A SYNTAX IN MY PHP SCRIPT, I CHECKED IN ERROR LOG