MySQL query not working

[Guest]

  $dbname = $_POST['dbname'];
  $installQuery = "
    SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";
    CREATE DATABASE `$dbname` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
    USE `$dbname`;
  ";

 

Do I have to manually create the database with a php function or should this work?

[akitchin]

well the first and foremost issue is that you can only run one query at a time using mysql_query().  separating them by semicolons won't work, and will trigger an SQL syntax error.

 

whether those statements are allowed or not is beyond me - i would imagine it depends on the host setup and whether or not the user you're trying to run it with has permission.