Problem creating new database through php

xxATOMxx

Ok, I hope this makes sense...

Through php I have no problem connecting to, quering (spelling?), viewing a database that Ialready made in MySQL, BUT I cannot create a new one using strictly php. It has to be made through the shell in MySQL first. I am using:

mysql_create_db("New_Database")
or die(mysql_error());

And I get an error on this specific line
it gives me the good old:

Fatal error: Call to undefined function: mysql_create_db()

I'm not sure if anyone can help, I have seen other posts with people who have the same error but their reasons are diffrent than mine. Am I even posting this in the right section of this forum? (This is my first post)

xxATOMxx

I put this post in the php/mysql section because I think it may belong there...It was a toss up because I am a newbie, with a newbie question...

NightCoder

Try using @mysql_create_db("name");

The reason for this is when you do mysql_create_db("name"); php takes it as a php function insted of a sql.

BIOSTALL

I always thought that the @ symbol was placed in a command so that if an error occurs, the default php-created error message is eliminated and the 'die' string was echoed instead :bemused: Oh well, my bad, lol.

BIOSTALL

onion2k

Biostall is right, Nightcoder is making shit up.

I imagine the problem is this: "This function will not be available if the MySQL extension was built against a MySQL 4.x client library." To create a database use this instead:

mysql_query("CREATE DATABASE IF NOT EXISTS womble");

That would create a database called 'womble'. This assumes that the user you're connecting to the database has the right privs needed to actually create databases.. something that a standard mysql user account shouldn't really have as its a small security risk.