php&amp;mysql help plz

php&mysql help plz

benzspida

trying to create a new database with 4 table in php $ mysql
cant seem to get the script working can any one help plz

this is what i have done so far

<html>
<head>
<title>
mysql databser
</title>
</head>
<body>

<? php

$new_db = "testDB2";

$connection= @mysql_connect ("localhost", "craig", "1978")

die (mysql_error());

$result = @mysql_create_db ($new_db, $connection)

die (mysql_error());

if ($result) {
$msg = "<P>Database has been created!</p>";

print " $result";

}

<p> <? echo "$msg"; ?></p>
</body>
</html>
Edit/Delete Message

FatalError

Woah...that has like 10 mistakes in it. Here, fix it to this:

<html>
<head>
<title>
mysql databser
</title>
</head>
<body>
<? php

$new_db = "testDB2";

$connection = mysql_connect("localhost", "craig", "1978");
if (!$connection)
{
die("Could not connect to the server");
}

$result = mysql_create_db($new_db, $connection);

if ($result)
{
$msg = "Congrats! Your database has been created!";
}
else
{
die("Could not create a new database");
}

?>

<p><?php echo $msg; ?></p>
</body>
</html>

You had 2 die functions in there for no reason. Of course it didn't work! You ended the script by dying! And never put @ signs in front of functions when you are debugging. Also, if you echo out $result, you'll just get a boolean, true or false, so that doesn't exactly help you.

This one should work.