Thread: Problems
View Single Post
  #2 (permalink)  
Old 05-14-2008, 02:04 PM
Ukuser26 Ukuser26 is offline
Junior Member
 
Join Date: Apr 2008
Posts: 7
Default fixed

class searchAll{

function __construct($dbIn){
$this->db = $dbIn;
}

private function allowedImages($cid){
$db = $this->db;
$sql = "Select * from test where test_id='$cid'";
$r = $db->fetchAll($sql);
foreach ($r as $k=>$arr){
$arrN[] = $arr['name'];
}
return $arrN;
}

public function imageSearch(){
$db = $this->db;
$search = $db->fetchAll("Select * from test");

foreach ($search as $k=>$arr){
$cid = $arr['test_id'];
echo $cid;
print_r($this->allowedImages($cid));
echo "<hr>";
}
}
}

Was using query - should have used a fetchAll
Reply With Quote