<?php

$dbcnx = @mysql_connect("localhost", "username", "password");

if (!$dbcnx) {
 echo( "<P>Unable to connect to the " .
       "database server at this time.</P>" );
 exit();
} else {

echo ' Connected to the database server!';
}
//time to connect to the database
mysql_select_db("database_name", $dbcnx);

if (!@mysql_select_db("database_name") ) {
 echo( "<P>Unable to locate the Calendar " .
       "database at this time.</P>" );
 exit();
}


?>

<?
// connect to mysql and select database
$db = mysql_pconnect("localhost","USER","PASS");
mysql_select_db("DATABASENAME",$db);

// build query
$create = "CREATE TABLE news(
id INT(5) unsigned NOT NULL auto_increment,
author VARCHAR(32),
content TEXT,
posted DATE,
PRIMARY KEY (id));";

// run the query
mysql_query($create);
?>