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] Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/12371-empty-result-set-problem/#findComment-47651 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.