[SOLVED] Error - No Database Selected

[limitphp]

I installed WAMPSERVER to setup a test machine to work on php and MYSQL.

I keep getting the error: "No Database Selected".

 

Here's the code I'm using:

$con = mysql_connect("localhost"); 
mysql_select_db("Testdata");


$sql = "CREATE TABLE person 
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);

 

 

Does anyone know why I'm getting this error?

Do you have to setup a DNS for the MYSQL database in the control panel?

[aebstract]

mysql_connect("localhost","username","password") or die(mysql_error());
mysql_select_db("database");

You have to have your username/password to log in to your database.

[limitphp]

mysql_connect("localhost","username","password") or die(mysql_error());
mysql_select_db("database");

You have to have your username/password to log in to your database.

 

This might sound silly, but I'm not sure what the username or password is.  I just installed WAMPSERVER.

I read somewhere that you can use

 

mysql_connect("localhost","root");

 

But that didn't seem to work either.

Is there a way to find out what the password/username is?

I have WAMPSERVER running right now on my test machine.

[havik]

try to connect with

mysql_connect('localhost', 'root', '') or die (mysql_error());
mysql_select_db ('databasename'); or die (mysql_error());

[limitphp]

try to connect with

mysql_connect('localhost', 'root', '') or die (mysql_error());
mysql_select_db ('databasename');

 

I tried the above, but I got the same "No Database selected"

here's what my code looks like now:

 

$con = mysql_connect('localhost', 'root', '') or die (mysql_error());
mysql_select_db ('Testdata');

$sql = "CREATE TABLE person 
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);	

 

Maybe I'm not setting up the database Testdata correctly.

 

Its int he same directory as my test website.

I have my test website in C:/wamp/www/testwebsite/

 

I setup the database to be in the same location.

I also tried putting it in C:/wamp/www/

 

Was I supposed to setup the DSN in the control panel using the ODBC?

 

Or is that only with access databases?

 

 

[havik]

just wondering did u create a d-base called Testdata?

 

try opening http://localhost/phpmyadmin

i think wamp has got it (i know xampp does)

 

[Barand]

run this script to see what databases you have

 

<?php
mysql_connect('localhost') or die ("Connect error");

$res = mysql_query("SHOW DATABASES");
while ($row = mysql_fetch_row($res))
{
    echo $row[0], '<br/>';
}
?>

 

You should get something like

[pre]

information_schema

mysql

test

world

[/pre]

[limitphp]

just wondering did u create a d-base called Testdata?

 

try opening http://localhost/phpmyadmin

i think wamp has got it (i know xampp does)

 

 

Thank you guys!  Success!

 

I had built the database in the SQLiteManager, not the phpMyAdmin.

Once I built it in the phpMyAdmin it worked!

 

I'm confused, though, what is the difference between the two?

 

[wildteen88]

They manage two different types of SQL databases.

 

phpMyAdmin is used for managing MySQL Databaes.

SQLiteManager is used for managing SQLite Databases

[limitphp]

They manage two different types of SQL databases.

 

phpMyAdmin is used for managing MySQL Databaes.

SQLiteManager is used for managing SQLite Databases

 

Oh, I see.

Thanks alot guys, I appreciate the help.