Welcome Guest, Not a member yet? Register   Sign In
Select Query Error
#1

Hi everyone, i have a problem with a select query, 


Code:
$where = "SELECT FORMAT(SUM(payed), 2) AS payedAmount FROM client_credit WHERE creditStatus = 2 AND idperson = '"
           .$post_data['idperson']. "' AND contractDate
       BETWEEN '"
           . $startDate . "' AND '" . $endDate . "'";
$query = $this->db->query($where);
       if ($query->num_rows() > 0) {
           return $query->result();
       } else {
           return null;
       }

But i get a boolean result, $query = false, and when i execute the same query in mysql console i get the right result, but here i get boolean.

Thank you. Confused
Reply


Messages In This Thread
Select Query Error - by lfmluis - 06-12-2019, 11:51 AM
RE: Select Query Error - by jreklund - 06-12-2019, 01:36 PM
RE: Select Query Error - by Wouter60 - 06-12-2019, 01:39 PM
RE: Select Query Error - by hc-innov - 06-12-2019, 01:46 PM



Theme © iAndrew 2016 - Forum software by © MyBB