I created a database called roccle_guestbkdb in the MySQL Databases section of the Free Hostia Control Panel. The database name then appeared correctly under the "Database Name / Database Username" heading below.
However, after logging into phpMyAdmin, I am unable to create a table using an SQL query. I get the error message "#1046 - No database selected".
Below is the SQL query I was using:
CREATE TABLE `comments` (
`id` INT( 5 ) NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 60 ) NOT NULL ,
`email` VARCHAR( 60 ) NOT NULL ,
`website` VARCHAR( 60 ) NOT NULL ,
`message` VARCHAR( 300 ) NOT NULL ,
`date` VARCHAR( 10 ) NOT NULL ,
INDEX ( `id` )
) ENGINE = MYISAM ;
I'd appreciate your help with this matter.
Thank you,
R.C.
|