Cannot create table from a PHP script

Namadoor

Hello, I have a script that is suppost to create a table in from a PHP script, in a database.

The PHP code for that goes like this

$query = "CREATE TABLE $gbname
(gbid int not null primary key auto_increment); ";

mysql_query($query)	or die("Could not create table");

That doesn't work, it gets a parase error, however, when I do it from the command line under the same user, it does work. I have all the privleges set correctly. What's wrong?

[deleted]

Seeing zero responses so far, I will try to help.

Unless you have not filled in all the script (?), nothing in your script has you connecting to the database.

Here's what I mean:

$dbconn = mysql_connect("localhost", "username", "password");
$result = mysql_select_db("database_name", $dbconn);

This is taken from the pretty good tutorial here: http://www.newbienetwork.net/content.php?id=3

Then once you've created a connection to the database, you should be able to run the queries from your script.
I'm tired so this may be wrong but I'm sure that if its wrong, someone will straighten it out.

HTH:rolleyes:

Namadoor

I did have a connection to the database, I just didn't show that. Also - I am getting a parase error, so if it wern't connecting to the database, I don't think I would get that.

MrAlaska

A parse error means PHP is not able to even read the page. I don't see anything in that line would generate a parse error, it is probably coming from some other line. The only thing odd I see is the $ in front of your table name. The table name is a variable?

mikesgt2

Please could you post the entire code? We may be able to be of more help then.

adywarna

You have a semicolon after the right bracket, and then a whitespace. I tried your code and these work:

$query = "CREATE TABLE $gbname
(gbid int not null primary key auto_increment)";

$query = "CREATE TABLE $gbname
(gbid int not null primary key auto_increment);";

NOt this one:

$query = "CREATE TABLE $gbname
(gbid int not null primary key auto_increment); ";

Well, maybe.