Hi I have this function:
public function GetFreeOptionsArray($itemId){
$db = getDatabase();
$sql = "
SELECT msio_msop_id
FROM cms_tmodule_shop_item_option
WHERE msio_msi_id = $itemId
";
$result =& $db->query($sql);
if(PEAR::IsError($result)) {
die("Error retreiving product item options : " . $result->message);
}
while($row =& $result->fetchRow()){
foreach($row as $itemId){
$returns = $this->ProcessFreeOptionsArray($itemId);
return $returns;
}
}
}
yet I can only seem to access the first result.
Can anyone please help - this is driving me mad