New to php. Can't create new table.

[orangerobot]

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

 

 

[PunjabHaker]

try

mysql_connect("localhost",$user,$password);

not

mysql_connect(localhost,$user,$password);

[orangerobot]

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?

[trq]

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.