Posted by Gordon Burditt on 10/11/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

• Next in forum: Re: PHP 5 Extension not loading properly.
• Prev in forum: creating a table via mysql
• Thread view: Re: creating a table via mysql

[Reply to this message]