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