[SOLVED] Creating Database with form and php

[big-dog1965]

Im getting an error with this can someone tell me the problem

The htm form

<form method="post" action="createdb.php"> 
User Name: <input type="text" name="user" /> 
Password: <input type="password" name="pass" /> 
Database Name: <input type="text" name="dbname" /> 
<input type="submit" /> 
</form>

This is the php

<?php
$con = mysql_connect("localhost",$_POST["user"],$_POST["pass"]);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE".$_POST["dbname"],$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_close($con);
?>

This is the error

Error creating database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASEmydb' at line 1

[gevans]

You need a space before the database name

 

"CREATE DATABASE".$_POST["dbname"]

 

should be;

 

"CREATE DATABASE ".$_POST["dbname"]

[big-dog1965]

that got rid of that error but now I get cant creat db. I sent a ticket to my host to see why I dont have the priv to create DB without going into cp