I wrote this page to receive from a signup page. It redirects, doesn't show any error but phpmyadmin doesn't recognize the database i tried creating, i.e I can't even see the database in phpmyadmin. Whats wrong?
<html>
<body>
<?
$con = mysql_connect_db("localhost", "user", "");
$create_db = mysql_query('CREATE DATABASE USER', $con);
if($create_db)
{
echo "wored";
}
$dbcreate = mysql_query('CREATE DATABASE USER',$con);
mysql_select_db($dbcreate);
$create = "CREATE TABLE USER1 (userid INT(20) AUTOINCREMENT NOT NULL, username VARCHAR(15) PRIMARY KEY NOT NULL, password VARCHAR(15) NOT NULL)";
mysql_query($create);
$query="INSERT INTO USER1(username,password) VALUES('$_POST[username]', '$_POST[password]');
$result=mysql_query($query);
mysql_close($con);
?>
<?php
header('location:loginpage.html');
?>
