[php & MySQL] Creating database and tables not working!

programming
1

**Hi all,
**Not having such a good time at the moment. I have made a script from tutorials on how to create a MySQL database with PHP and I can do it its just when I want to add my second table it will not work.

this is the PHP code of the create.php file:

<?php
include 'config.php';
include 'opendb.php';

$query  = 'CREATE DATABASE blog779';
$result = mysql_query($query);

mysql_select_db('blog779') or die('Cannot select database');

$query = 'CREATE TABLE admin( '.
         'id INT NOT NULL AUTO_INCREMENT, '.
         'username TEXT NOT NULL, '.
         'password TEXT NOT NULL, '.
         'email TEXT NOT NULL, '.
         'PRIMARY KEY(id))';

         'CREATE TABLE admin( '.
         'id INT NOT NULL AUTO_INCREMENT, '.
         'username TEXT NOT NULL, '.
         'password TEXT NOT NULL, '.
         'email TEXT NOT NULL, '.
         'PRIMARY KEY(id))';

         

$result = mysql_query($query);

include 'closedb.php';
?>

can you see anything wrong?