need help with this code

[T12]

hi, this is my first try at php and just need to know is this code right as im getting errors but dont know if its my code or the sever side


<?php

//CONNECT MYSQL and SELECT TABLE;

$host = "localhost"; //host name;
$username = "test"; //mysql server login name;
$password = "test"; //mysql server login password;

//database Name;

$database = "test";

//PREPARE sql statement;

$sql1 = "CREATE DATABASE $database";

//EXECUTE sql statement;

$exq1 = mysql_query($sql1);

//reply us the database is created or not;

if($exq1) {

echo "database created";

} else {

echo "error while create database";

}

?>

[navaldesign]

Re: need help with this code

VH has Cpanel, which doe NOT allow creation of Databases through a query.

You need to create your database through CPanel.

[Watdaflip]

Re: need help with this code

You should be able to create the database manually through a script, using your cpanel username/password in the script.

[navaldesign]

Re: need help with this code

Hm.... I can't be certain, but i believe not. Even phpMyAdmin which by default uses the cpanel usename / password, has privilleges to create a new database.