RE: [PHP-WIN] error. no database selected problem solved!

2004-10-26 Thread Zareef Ahmed
lto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 7:18 AM To: [EMAIL PROTECTED] 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 "ph

[PHP-WIN] error. no database selected problem solved!

2004-10-26 Thread Patrick Roane
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, firstNa

[PHP-WIN] error. no database selected.

2004-10-26 Thread Patrick Roane
Ok, No syntax errors this time, but when I hit enter (after I type in the code below), I get 'error 1046, no database selected' CREATE TABLE phonelist( id INT(100) PRIMARY KEY, firstName VARCHAR(15), lastName VARCHAR(15), email VARCHAR(20), phone VARCHAR(15) ); There must