Jump to content

Empty result set problem :(


CrazyIvan

Recommended Posts

Hey there

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 infact return one row. Could anyone shed some
light on my situation?

Thanks so much, here's a summary of my code below

[code]function blah($id, $indicator){

$sql = 'SELECT ksi_detail.value
FROM cornelius_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;

}[/code]
Link to comment
https://forums.phpfreaks.com/topic/12371-empty-result-set-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.