config.php
<code lang="PHP">
$config = array(
	
//Database Connections
"db_host" => "localhost",
"db_user" => "######",
"db_password" => "######",
"db_database" => "######",

"dev" => true, //true=don't send emails, print to screen, false=don't print to screen, send emails

//Admin Stuff
"admin_email" => "Your email here"
);
</code>

class.mysql.php
<code lang="PHP">
<?php

class mysql{
	
	var $queryCounter 	= 0;
	var $totalTime 		= 0;
	
	function mysql(){
		global $config;
		$host 			= $config['db_host'];
		$db_user 		= $config['db_user'];
		$db_pass 		= $config['db_password'];
		$db 			= $config['db_database'];
		
		$startTime = $this->getMicroTime();
		
		mysql_connect($host, $db_user, $db_pass) or die("Could not connect to database");
		mysql_select_db($db) or die("Could not select database ".$db);
		
		$this->totalTime += $this->getMicroTime() - $startTime;
	}
	
	//Executes and returns a query
	function query($sql) {
		$startTime = $this->getMicroTime();

		++$this->queryCounter;
		
		$result = mysql_query($sql);

        if (mysql_error()) {
			$this->mailError($sql, mysql_error(), mysql_errno());
			return $this->error("<br />There was a SQL error and it has been reported. Sorry for the inconvience.<br />");
        }
		
		$this->totalTime += $this->getMicroTime() - $startTime;
		
        return $result;
	}	

	//Fetch array Query MySQL Database
	function fetch($result) {
		$rows = mysql_fetch_array($result);
		return $rows;
	}
	
	//Fetch array Query MySQL Database
	function fetch2($result) {
		$rows = mysql_fetch_array($result, MYSQL_ASSOC);
		return $rows;
	}
	
	function fetchO($result) {
		$row = mysql_fetch_object($result);
		return $row;
	}
	
	function fetchRow($result) {
		$rows = mysql_fetch_row($result);
		return $rows;
	}

	//Count the number of rows in query
	function numRows($result) {
		$count = mysql_num_rows($result);
		return $count;
	}
	
	//Run query and count the number of rows in query
	function numRowsQ($sql) {
		$result = $this->query($sql);
		$count = mysql_num_rows($result);
		return $count;
	}
	
	// Returns only one column
	function fetchOneCol($sql, $arr=0) {
		$result = $this->query($sql);
		$return = $this->fetch($result);
		$return = $return[$arr];
		return $return;
	}
	
	// Find number of fields names in a query
	function numFields($result) {
		$fields = mysql_num_fields($result);
		return $fields;
	}
	
	// find single field name 
	function fieldName($result, $fNum) {
		$name = mysql_field_name($result, $fNum);
		return $name;
	}
	
	//Get affected rows
	function getAffectedRows()
	{
		return mysql_affected_rows();
	}	
	
	//Get last insert id
	function getInsertId(){
		return mysql_insert_id();
	}
	
####################################################
#		Time/Count Functions
####################################################
	
	function getDBTime($dec=6){
		$time = number_format(round($this->totalTime, $dec), $dec);
		return $time;
	}
	
	function getSqlCount(){
		return $this->queryCounter;
	}
	
  	function getMicroTime() {
    	list($usec, $sec) = explode(" ",microtime());
    	return ((float)$usec + (float)$sec);
    }
	
	function showSQLStats($dec=6){
		$stats = $this->getSqlCount();
		$stats != 1 ? $stats .= " queries took " : $stats .= " query took ";
		$stats .= $this->getDBTime($dec) . " seconds to execute";
		return $stats;
	}
	
####################################################
#		Error Handling
####################################################
	// Sends an email to the admin on an error
	function mailError($sql, $error, $errorNo) {
		global $config;
		if ($config['dev']){
			print $sql . "<br /><br />" . $error . "<br /><br />" . $errorNo . "<br /><br />";
		}else {
			mail($config['admin_email'], "SQL Error on ".$config['site_name'], $sql . "\n\n Error Msg: " . $error . "\n\n Error Number: " . $errorNo . "\n\n Page: " . $_SERVER['REQUEST_URI'], "From: " . $config['admin_email']);
		}
	}
	
	// error function
	function error($msg) {
		print $msg;
		die();
	}


}

?>
</code>

test_mysql.php
<code lang="PHP">
<?php 

require_once "config.php";
require_once "class.mysql.php";
$db = new mysql(); 

//Just make a standard query and put it into a result
$select = "SELECT * FROM users";
$result = $db->query($select);

//Get a row count from result
$count = $db->numRows($result);

//Loop through query
while($row = $db->fetch($result)){
	$username = $row['username'];
	$fullname = $row['fullname'];
	
	echo "$username - $fullname <br />";
}

//get just the count of a query
$select = "SELECT * FROM users";
$count = $db->numRowsQ($select);

//Just fetch on column
$select = "SELECT name FROM users WHERE userid = 1";
$name = $db->fetchOneCol($select);

//Get last inserted ID
$insert = "INSERT INTO users (username, password) VALUES ('test','test')";
$db->query($insert);
$userid = $db->getInsertId($insert);

//at the bottom of the page show how many queries were executed and how log it took...you can also put a decimal place in (default is 6)
echo $db->showSQLStats(); //default 6 decimal places
echo $db->showSQLStats(2); //2 decimal places

/*
Error reporting:

"dev" => true,
This will print the sql query, error number, and message to the screen

"dev" => false,
This will print "There was a SQL error and it has been reported. Sorry for the inconvience." only to the screen. An email will get sent to "admin_email" => "Your email here" with the sql query, error number, and the page that had the error on it so you can go back and check it out yourself.

*/

?>
</code>