<?php
$host = "driftwood";
$user = "s_brianb";
$pass = "YOUT PASS HERE";
$database = "s_brianb";

$con = mysql_connect($host,$user,$pass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$db = mysql_select_db($database);
if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }


$table = "CREATE TABLE BestMovies
			 (title varchar(50),
			 PRIMARY KEY(title),
			 year smallint(4),
			 director varchar(40),
			 genre varchar(20),
			 rating tinyint(2))";

// Execute query
$result = mysql_query($table,$con);

if ($result !== false) {echo "It worked";}

//mysql_close($con);
?>