MORE HELP - create new database if it doesn't exist

rupertbj

Please see the amended code:

<?php
if ((!ereg(".+@.+..+", $user)) || (!ereg("^{[a-zA-Z0-9_@.-]+$",} $user)))
{
print "
<body bgcolor=\"#8080FF\">
<b>Invalid Email address! Please <a href=/index.html>register</a> properly!!!</b>
";
exit;
}
else
{
setcookie( "user", $user, "0" );
$db = "register";
$link = mysql_connect( "localhost:/users/rupertbj/domains/rupstar.co.uk/sql/mysql.sock", "root" );
if ( !$link ) die( "Couldn't connect to MySQL" );

if (!(mysql_select_db( $db, $link )))
     {
        $query="CREATE database register";
		mysql_query( $query, $link );
		$query="CREATE TABLE user (email VARCHAR (50) not null , UNIQUE (email))";
		mysql_query( $query, $link );
     }

mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );		 
$sql = "INSERT INTO user VALUES ( '$user' )";
mysql_query( $sql, $link );
mysql_close( $link );
}

This creates the database but not the table - i obviously missed something!

Thanks in advance for your help......again!

rupertbj

jerdo

Try putting this after between the database creation line and the table creation line.
mysql_select_db("register",$link);

rupertbj

I'll get the hang of this one day!!!

rupertbj