PageTitle); $seperator = 1; if(count($arr) >2) $seperator = 2; for($i=0;$i"; print $arr[$i]." "; } if(count($arr) > $seperator) print ""; ?>

ImageUrl) > 0){ print "ImageUrl."\" />"; } ?>

PageContant; // list of financials /* $sql = "select count(*) Total from finantials group by year(FinancialMonth),month(FinancialMonth) order by year(FinancialMonth)desc,month(FinancialMonth) desc"; $rs = mysql_query($sql,$con); $TotalRecord = 0; if($row = mysql_fetch_object($rs)) $TotalRecord = $row->Total; $sql = "select YEAR(FinancialMonth)Year,MONTH(FinancialMonth)Month ,DATE_FORMAT(FinancialMonth,'%M %Y')fDate,FileUrl from finantials group by year(FinancialMonth),month(FinancialMonth) order by year(FinancialMonth)desc,month(FinancialMonth) desc"; $Paging = new CustomPaging(); $Paging->Conn = $con; $Paging->Sql = $sql; $Paging->url = "index.php?"; $Paging->TotalRecords = $TotalRecord ; $Paging->RecordPerPage = 10; $Paging->NoOfPaginglinks = 5; $Paging->Generate(); print ''; while($row = mysql_fetch_object($Paging->RecordSet)){ print ''; } print '

'.$row->fDate.'

'; $sqlinner = "select finantials.ID,finantials.NavID,FileUrl,navtype.Title from finantials inner join navtype on navtype.NavID = finantials.NavID where MONTH(FinancialMonth) = ".$row->Month." and YEAR(FinancialMonth) = ".$row->Year. " order by finantials.NavID asc"; $rsinner = mysql_query($sqlinner,$con); print '
    '; while($rows = mysql_fetch_object($rsinner)){ print '
  • '.$rows->Title.'
  • '; } print '

'; ?>