PHP Tutorial - Creating a Database

Create a DB
     <?
     mysql_connect('localhost');
     if(mysql_query("CREATE DATABASE foo")) {
     echo "Database foo created";
     } else {
     echo mysql_error();
     }
     ?>

Output:
     Database foo created

Create a Table
     <?
     mysql_select_db('foo');
     $result = mysql_query("CREATE TABLE users (
     id varchar(16) binary NOT NULL default '',
     Password varchar(16) NOT NULL default '',
     Name varchar(64) default NULL,
     email varchar(64) default NULL,
     ts timestamp(14) NOT NULL,
     PRIMARY KEY (id)
     )");
     if($result) {
     echo "Table created";
     } else {
     echo mysql_error();
     }
     ?>

Output:
     Table created