CODEWITHSUNDEEP
phpsqlwhere-clause
user3590094
user3590094

Reputation: 119

Simple PHP SQL WHERE

My code looks :

$sql = "SELECT SUM(kolicina_djeca) FROM rezervacije WHERE datum_od = '$datefrom'";


$res = mysqli_query($connection,'SELECT SUM(kolicina_djeca) FROM rezervacije WHERE datum_od = "$datefrom"');

var_dump($res);
if (FALSE === $res) die("Select sum failed: ". mysqli_error($connection));
$row = mysqli_fetch_row($res);
$sum = $row[0];
var_dump($sum);

I get always results NULL , but in phpmyadmin when i run same SQL statement i get integer 13.

Here is what i'm running in phpmyadmin:

SELECT SUM(kolicina_djeca) FROM rezervacije WHERE datum_od = "12-08-2018"

Upvotes: 1

Views: 58

Answers (1)

user2852575
user2852575

Reputation:

Please update your query as given below....

$sql = "SELECT SUM(kolicina_djeca) as sum FROM rezervacije WHERE datum_od = '$datefrom'";

Also, you have to replace your $row[0] with $row['sum']

$sum = $row['sum'];

I hope this will fix your problem

Upvotes: 2

Related Questions