🚀 go-pugleaf

Area32 <webmasterATarea32PUNTbe> wrote:
> Ik probeerde het met een functie maar hoe meer ik probeerde hoe meer
> fouten ik krijg :-(

Probeer eens met mijn class:

	class mySQL
	{
		var $dbname = "database";	// database name
		var $dbhost = "hostname";	// mySQL server
		var $dbuser = "user";		// user for conn
		var $dbpass = "password";	// users' pass

		// Executes a query and returns the recordset
		function RecordSet($SQL) 
		{
			$link = mysql_connect($this->dbhost, $this->dbuser, $this->dbpass); 
			mysql_select_db($this->dbname);
			
			$rs = mysql_query($SQL);
			
			return $rs;
			
			$this->DBClose($link); 
		}
		
		// Counts the number of rows in a recordset
		function RecordCount($rs) 
		{
			return mysql_num_rows($rs);
		}

		// Returns a 2D associative array of rows
		function GetRows($rs) 
		{
			$arr = array();
			$counter = 0;
			
			while ($row = mysql_fetch_array($rs)) 
			{
				$arr[$counter] = $row;
				$counter++;
			}
			
			return $arr;
		}

		// Close the database connection
		function DBClose($link) 
		{
			mysql_close($link);
		}
	
		// Print an error
		function Status() 
		{
			$errno = mysql_errno();
			$error = mysql_error();

			return "($errno)<br/>$error";
		}
	}

Hier nooit last mee,

Wat voor errors krijg je zoal?

 - Philip

-- 
Philip Paeps                                                   philip@paeps.cx

  You sure have to borrow a lot of money these days to
  be an average consumer.