I am using mysql query as
SELECT tpa_name
FROM `patient_detail` p, daily_ward_entry d
WHERE d.general_regn_no = p.general_regn_no
AND d.id =3
I am getting the result as 1 and Null when d.id =1
But in controller public function actionCharges($id)
$query = (new \yii\db\Query())
->select('tpa_name')
->from('patient_detail')
->innerJoin('daily_ward_entry',
'daily_ward_entry.general_regn_no = patient_detail.general_regn_no');
$command = $query->createCommand();
$rows = $command->queryAll();
var_dump($rows);exit;
when I am viewing the page using daily-ward-entry/charges&id=3 I am getting the dump values as Null in all cases. I am scratching my head what I am doing wrong here?