heres what I use.
//mySQL.php
<?php
require_once('util.php');
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', 'illumina_rpg');
$con = "";
function connect_mySQL()
{
global $con;
$con = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD);
if (!$con) die('Could not connect: ' . mysql_error());
mysql_select_db( DB_DATABASE, $con);
return $con;
}
function close_mySQL()
{
global $con;
mysql_close($con);
}
function write_mySQL( $query )
{
global $con;
if (!mysql_query($query,$con)) die('Error: ' . mysql_error());
}
function read_mySQL( $query )
{
return mysql_query($query);
}