Posted by Gordon Burditt on 11/13/98 11:20

>$mysql_link = mysql_connect($hostname, $username, $password);
>mysql_select_db($databasename);
>$create = "CREATE TABLE 'photosgigs' ('id' INT(4) NOT NULL AUTO_INCREMENT,
>'table_gal' VARCHAR(100) NOT NULL, 'gallery' VARCHAR(100) NOT NULL, PRIMARY
>KEY ('id'))";
>mysql_query($create,$mysql_link) or die(failed);
>
>with $hostname, $username & $password set.
>
>This won't create a table, can you give me any ideas y?

Use print mysql_error() to find out why.

My guess is that the quotes should be backquotes. Look at the error
message to be sure. You also might not have sufficient privileges
to create tables.

Gordon L. Burditt

[Back to original message]