CrazyIvan Posted June 19, 2006 Share Posted June 19, 2006 Hey thereI 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 somelight on my situation?Thanks so much, here's a summary of my code below[code]function blah($id, $indicator){$sql = 'SELECT ksi_detail.valueFROM cornelius_saved_ksi_detail ksi_detailWHERE 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 More sharing options...
fenway Posted June 20, 2006 Share Posted June 20, 2006 Which array is empty? Where's the echo line? I don't see any return values from the blah() function which is also never called. Link to comment https://forums.phpfreaks.com/topic/12371-empty-result-set-problem/#findComment-47651 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.