Problem in creating a database

i tried to create a table using this code"CREATE TABLE news(
id INT NOT NULL AUTO_INCREMENT,
title VARCHAR(50) NOT NULL,
content TEXT NOT NULL,
PRIMARY KEY(id)
);
"

but i am getting error "no database selected "

Can you help me how to select a database while creating a table?

 

Read this : http://www.php-mysql-tutorial.com/connect-to-mysql-using-php.php or just google it http://www.google.com/search?q=mysq...s=org.mozilla:en-US:official&client=firefox-a

 

can't u use phpmyadmin? if not before executing that query give a mysql_select_db("databasename");

 

you must select an existing database or create new database before you can add or create new tables

 

Hello,

You have problem in Problem in creating a database or a Table news.
Furthermore, provide details how u are creating.
Using code in php or using any database tool such as phpmyadmin.

 

if you have access in phpmyadmin go there and select a database and then run your query.
that should work