simple mysql class.
usage: change predefined vars under 'mysql server configuration' to suit your environment.

example.php -

<?php
include 'mysql.class.php';
$mysql = new mysql_db();

//result will always be in array format
$result = $mysql->fetch_array('SELECT * FROM `table`');

printf('<pre>%s</pre>', print_r($result, 1));

$mysql->query('UPDATE `table` SET `id` = 23 WHERE `id` = 22');
?>

<?php
/**
 *  @author Sean Wragg <seanwragg@gmail.com>
 *  @version 1.0 bRC3 mysql.class.php
 */

class mysql_db {
    // mysql server configuration
    private $dbhost = 'localhost';
    private $dbuser = 'username'; 
    private $dbpass = 'password'; 
    private $dbname = 'database';
    protected $mysql;

    // check if connection is alive, if not establish it
    function __construct() {
        if ( !is_resource($this->mysql) ) {
            $this->mysql = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpass );
            mysql_select_db( $this->dbname, $this->mysql ) or $this->error();
        }
    }

    // error reporting
    private function error() {
        return printf( '<b>MySQL ERROR:</b> %s (%d)', mysql_error(), mysql_errno() );
   }

    // handles queries resulting in output
    public function fetch_array( $query ) {
        $mysql_query = mysql_query( $query, $this->mysql );
        while( $result = mysql_fetch_array( $mysql_query, MYSQL_ASSOC ) ) {
            $return[] = $result;
        }
        return $return;
    }

    // handles statements: update, insert etc. 
    public function query( $query ) {
        return mysql_query( $query, $this->mysql );
    }
}

?>