Forum Moderators: coopster
I was just wondering if anyone has ever encountered the problem I am having.
I am running a sql query within my php script, which is returning an empty array. The funny thing is, if I echo out the sql query and run it in phpmyadmin, it does in fact return one row. Could anyone shed some light on my situation?
Thanks so much, here's a summary of my code below
function blah($id, $indicator){
$sql = 'SELECT ksi_detail.value
FROM company_saved_ksi_detail ksi_detail
WHERE ksi_detail.saved_ksi_id_fk = '.$id.'
AND ksi_detail.indicator_id_fk = '.$indicator;
$this->dao->fetch($sql);
$temp = $this->getItems();
}
function getItems{
$detail = array();
while ($row=$this->getItem())
{
$detail[] = $row;
}
return $detail;
}
Thanks!