<?
//*****************class seperator*************************
	class tfcsql{
				var $sqlsvr,$sqlusr,$sqlpwd,$reterror="",$linkident,$db,$result,$count;
				
				//------------function seperator-------------------------pass=webpostfc01
				function tfcsql($sql="200.1.2.137",$usr="sa",$pwd="sa123",$db="FCMS")
				{
				$this->sqlsvr=$sql;
				$this->sqlusr=$usr;
				$this->sqlpwd=$pwd;
				$this->db=$db;
				$this->connect();
				}
				 //--------connects to server and selects database------------------------------
				 function connect()
				 {
				 		if (!isset($this->linkident))	 
							 if (($this->linkident=mssql_connect($this->sqlsvr,$this->sqlusr,$this->sqlpwd))==false)
				 			 {
				  		 $this->reterror="Error. Couldn't connect to $sqlsvr using $sqlusr!";
				  		 return $this->linkident;
				 			 }else 
							 		{
										 if (mssql_select_db($this->db,$this->linkident)==false)
										 $this->reterror="\nError. Unable to select DB";
										 return $this->linkident;
									}
				 		return $this->linkident;		
				 }
				 //--------------------------------------
				 function getlasterror()
				 {
				 return $this->reterror;
				 }
				 //--------------------------------------
				 function setsvr($svr)
				 {
				 	$this->sqlsvr=$svr;
				 }
				 //------------------------------------
				 function setusr($usr,$pwd)
				 {
				 	$this->sqlusr=$usr;
					$this->sqlpwd=$pwd;
				 }
				 //------------------------------------
				 function setdb($db)
				 {
				 	$this->db=$db;
				 }
				 //------------------------------------
				 function setall($svr,$usr,$pwd,$db)
				 {
				 		$this->sqlsvr=$svr;
						$this->sqlusr=$usr;
						$this->sqlpwd=$pwd;
						$this->db=$db;
				 }
				 //------------------------------------
				 function getident ()
				 {
				 		return $this->linkident;
				 }
				 //------------------------------------
				 function query($q)
				 {
				 	mssql_query("set ANSI_WARNINGS ON",$this->linkident);
					$this->result=mssql_query($q,$this->linkident);
					return $this->result;
				 }
 				 //------------------------------------
				 function count()
				 {
				 	$this->count=mssql_num_rows($this->result);
				 	return $this->count;
				 }
				 //------------------------------------
				 function result()
				 {
				 	return $this->result;
				 }
				 //------------------------------------
				
				 //------------------------------------
	
	}
//*******************************************************
?>