Welcome Guest, Not a member yet? Register   Sign In
How to view SQL generated by Query Builder?
#6

$sql= "SELECT COUNT(*) FROM business_components WHERE email= ? AND campaign= ? AND IUS= ?";
$query =$this->db->query($sql, [ $_SESSION['userid'],$_SESSION['campaign'],1]);
$res=$query->result();

This works except I don't know how to get the result

I tried this 'num_IUS' => $res[0]. The value in $res[0] is COUNT(*)="2". 2 is the correct answer but how do I get that into num_IUS?
proof that an old dog can learn new tricks
Reply


Messages In This Thread
RE: How to view SQL generated by Query Builder? - by richb201 - 08-09-2020, 12:34 PM



Theme © iAndrew 2016 - Forum software by © MyBB