<?
	function clientofferextension_get($clientcompanyid){
		$sql = "select	*
				from	tblclientofferextension
				where	clientcompanyid = " . db_number($clientcompanyid) . "
				or		clientcompanyid = 0";
		
		$offerextensions = db_query($sql);
		
		if($offerextensions){
			foreach($offerextensions as $offerextension_key => $offerextension){
				$sql = "select	*
						from	tblcustomfieldtype
						where	customfieldtypeid = " . $offerextension['customfieldtypeid'];
						
				$customfieldtype = db_first($sql);
				$offerextensions[$offerextension_key]['customfieldtype'] = $customfieldtype;
			}
			return $offerextensions;
		}
		else
			return false;
	}
?>