select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $dirPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $dirPath .= strtolower($res[0]['DirName']) ."/"; } $SQL = "SELECT * FROM portfolio_logo WHERE StoreID = '".$StoreID."' AND Status = 'Y' ORDER BY DisplayOrder"; $rs = $objDB->select($SQL); ?>