error. no database selected problem solved!

Thanks for all of your input. I didn't realize that I
had to 1st create the database:

mysql> create database phonelist;
Database "phonelist" created.


and than follow that up with:
mysql> use phonelist
Database changed

next:

mysql> create table table01(
id INT(100) PRIMARY KEY,
firstName VARCHAR(15),
lastName VARCHAR(15),
email VARCHAR(20),
phone VARCHAR(15)
);
Query OK, 0 rows affected (0.00 sec)

The next step is to put data into the table. Thanks
again for all help.

p





=====

----------------
"forget your lust for the rich man's gold. All that you need, is in your soul. You can do this if you try. All that I want for you my son, is to be satisfied"

~ Lynard Skynard

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: error. no database selected problem solved!

Dear Lynard Skynard,
Please do not change the subject every time you want to
add something to the thread. As thread change with the subject change.
Well informing "Solved" is a good practive in my view.

Zareef Ahmed

-----Original Message-----
From: Patrick Roane [mailto:fojomo@sbcglobal.net]
Sent: Wednesday, October 27, 2004 7:18 AM
To: php-windows@lists.php.net
Subject: [PHP-WIN] error. no database selected problem solved!


Thanks for all of your input. I didn't realize that I
had to 1st create the database:

mysql> create database phonelist;
Database "phonelist" created.


and than follow that up with:
mysql> use phonelist
Database changed

next:

mysql> create table table01(
id INT(100) PRIMARY KEY,
firstName VARCHAR(15),
lastName VARCHAR(15),
email VARCHAR(20),
phone VARCHAR(15)
);
Query OK, 0 rows affected (0.00 sec)

The next step is to put data into the table. Thanks
again for all help.

p





=====

----------------
"forget your lust for the rich man's gold. All that you need, is in your
soul. You can do this if you try. All that I want for you my son, is to
be satisfied"

~ Lynard Skynard

--

------------------------------------------------------------ ------------
--
Zareef Ahmed :: A PHP develoepr in Delhi ( India )
Homepage :: http://www.zasaifi.com

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php