<?
	function clientnegotiationextension_get($clientcompanyid){
		
		$sql = "select	*
				from	tblclientnegotiationextension
				where	clientcompanyid = " . db_number($clientcompanyid) . "
				or		clientcompanyid = 0";
		
		$negotiationextensions = db_query($sql);
		
		if($negotiationextensions){
			foreach($negotiationextensions as $negotiationextension_key => $negotiationextension){
				$sql = "select	*
						from	tblcustomfieldtype
						where	customfieldtypeid = " . $negotiationextension['customfieldtypeid'];
						
				$customfieldtype = db_first($sql);
				$negotiationextensions[$negotiationextension_key]['customfieldtype'] = $customfieldtype;
			}
			return $negotiationextensions;
		}
		else
			return false;
	}
?>