<?php $host="your ip"; $user="your usename"; $password="your passworld"; $database="database"; mysql_connect($host,$user,$password) or die(mysql_error()); echo "Connected to MySQL<br />"; mysql_select_db($database) or die(mysql_error()); echo "Connected to Database<br />"; //$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(); ?> |
|