<?php

class Model_DbTable_Squad extends Zend_Db_Table
{
	
	protected $_name = 'squad';
	public function GetMySquads_Of_User($ID){
       
    $select = $this->select();
    $select->from(array('S'=>"SquadsPlayers_NoImage_view"),array(
	"TID","SID","RugbyCode","FormDate","SquadName","TournName","Age","Position","SquadType","Jersey","Rank","Vice","PosName"
	));
	
    $select->setIntegrityCheck(false);
			$select->where("UserID ='".$ID."'  ");
			$lartYear = (date("Y")-1)."-12-31";
			$thisYear = date("Y")."-12-31";
			//$select->where("SquadType = 1 AND FormDate between '".$lartYear."' AND '".$thisYear."'  ");
			$select->where("FormDate between '".$lartYear."' AND '".$thisYear."'  ");
    $return = $this->fetchAll($select);
	if(count($return)>0){
		$return = $return->toArray();
	}
		return $return;
		
	}
	
	
	
   
}