Make a select question to DB

samsamtest

Hi I need to filter out what I want tol get back from the DB. where and how can I make question like this in datable?

if ($connection->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * fcount(*} from kund'";
$result = $connection->query($sql);

MSLtd

Hello @samsamtest , If it's specifically count(*) you're looking for, I'm pretty sure it isn't doable via DataTables functions - you'd have to do this through your own PHP scripts and then pass it into the DataTables system.

allan

DataTables is a Javascript library - I guess the equivilent is rows().data() which will give the data from the rows in the table. But I'm not certain that is what you are actually looking for.

Allan