各位大大好
小弟在用 pdo 時遇到問題
就是當我用連續兩個同名的 pdo query 後的物件時(像在loop中)
他會無法跑第二個
然後報 "2050 的錯誤"
網路上找解法是取不同名稱或把原本的名稱設成空值
可是這些方法我試過都行不通
請問還有什麼方法嗎?

補上程式碼

public function getSale($search_time, $option = array())
{
        $time_start = $search_time['search_year'].$search_time['search_month_start'];
        $time_end = $search_time['search_year'].$search_time['search_month_end'];

        $data_array = array();
        $show_sql = "
        select distinct isdept from test where yyyymm between '$time_start'           and '$time_end' order by isdept";
        $show_query = $this->link->query($show_sql);
        $shows = $show_query->fetchAll(PDO::FETCH_ASSOC);

        foreach ($shows as $show) {
            $sale_sql = "
            select isdept, dptnam, round(sum(depositqty)) as depositqty, round(sum(depositamtx)) as depositamtx, sum(qty) as qty, round(sum(amtx)) as amtx, round(sum(amtx-cost)) as profit
            from test m inner join invtest i using(isdept)
            where yyyymm between '$time_start' and '$time_end' and isdept = '".$show['isdept']."' and i.iclas='0' and i.isclas='0'
            GROUP BY isdept 
            order by isdept";
            $sale_query = $this->link->query($sale_sql);

            $data_array[$show['isdept']][$search_time['search_year']] = $sale_query->fetchAll(PDO::FETCH_ASSOC);
         }
return json_encode($data_array);
}

P.S: PHP使用 5.1版 原因可能會是版本太舊
但無法升級的情況下不知道有沒有什麼方式解決

---更新(問題已解決)
不使用 fetch 改採用 prepare + execute
迴圈尾端加上

$sale_query->closeCursor();
$sale_query = NULL;