orangerobot Posted February 8, 2007 Share Posted February 8, 2007 Hi all, I'm new to php/mysql. I've made some headway but I can't get past this basic issue. I'm uploading the text below as "createtable.php" to my web space but it keeps returning, "Unable to select database". <? $user="<my_username>"; $password="<my_password>"; $database="<my_database>"; mysql_connect(localhost,$user,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"; mysql_query($query); mysql_close(); ?> My phpinfo.php test file: <? phpinfo(); ?> returns all the PHP info including a section on mysql and my timetest.php file: <p>This page was created at < b> <?php echo date("h:i:s a", time()); ?> </ b> on the computer running PHP.</p> returns the current time as it should so I'm pretty sure my php and sql are up and running. But I can't figure out why I can't create a table ... it is maddening! Any help would be appreciated!! -OR Quote Link to comment Share on other sites More sharing options...
PunjabHaker Posted February 8, 2007 Share Posted February 8, 2007 try mysql_connect("localhost",$user,$password); not mysql_connect(localhost,$user,$password); Quote Link to comment Share on other sites More sharing options...
orangerobot Posted February 8, 2007 Author Share Posted February 8, 2007 Ok, that did it!!! Thanks! I also had to change my "localhost" to "mysqlxxx.secureserver.net" as specified at my godaddy hosting account. Why wouldn't localhost work since I'm running the php code on their local server? Quote Link to comment Share on other sites More sharing options...
trq Posted February 9, 2007 Share Posted February 9, 2007 Why wouldn't localhost work since I'm running the php code on their local server? More than likely there database servers and web servers are two different machines. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.