If you are using the mysql command line to process your definition, you will probably want to include;
Use dbname; Followed by your table creates. Hth, Warren Vail -----Original Message----- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 5:07 PM To: [EMAIL PROTECTED] Subject: [PHP-WIN] Re: error. no database selected. Have you tried using the function "mysql_select_db" to select the database? Patrick Roane wrote: > 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 be something I'm not doing. Any ideas? > > ===== > > ---------------- > "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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
