create tables

iZone

i have created one table for my website but these two create statements keep returning errors. The code is:

$conn = mysql_connect($hostname, $user, $pwd) or die ("Error: No connection to MySQL server\n"); 

mysql_select_db($dbname, $conn) or die ("Error: No Database Connection. \n"); 

$sql = "CREATE TABLE requests
(
request_RefNo INT(7) PRIMARY KEY NOT NULL AUTO_INCREMENT,
request_ClientID INT(6) NOT NULL default '',
request_Email VARCHAR(50) NOT NULL default '',
request_Area VARCHAR(25) NOT NULL default '',
request_Town VARCHAR(25) NOT NULL default '',
request_County VARCHAR(50) NOT NULL default '',
request_PropertyType VARCHAR(30) NOT NULL default '',
request_Garden VARCHAR(3) NOT NULL default '',
request_Parking VARCHAR(3) NOT NULL default '',
request_Location VARCHAR(20) NOT NULL default '',
request_Age VARCHAR(20) NOT NULL default '',
request_Price INT(6) NOT NULL default '',
request_Maxprice INT(7) NOT NULL default '',
request_Bedrooms INT(2) NOT NULL default '',
request_PropertyType VARCHAR(30) NOT NULL default '',
request_PaymentPlan VARCHAR(20) NOT NULL default '',
request_Notes TEXT NOT NULL default '',
request_Date DATETIME NOT NULL default ''
);";

$result = mysql_query($sql, $conn)or die("Failed Query of " . $sql);

and

$sql = "CREATE TABLE clients
(
client_id INT(6) NOT NULL AUTO_INCREMENT,
client_username PRIMARY KEY VARCHAR(25) NOT NULL default '',
client_password VARCHAR(40) NOT NULL default '',
client_Firstname VARCHAR(40) NOT NULL default '',
client_Surname VARCHAR(40) NOT NULL default '',
client_Address VARCHAR(40) NOT NULL default '',
client_Area VARCHAR(25) NOT NULL default '',
client_Town VARCHAR(25) NOT NULL default '',
client_Postcode VARCHAR(10) NOT NULL default '',
client_Phone VARCHAR(12) NOT NULL default '',
client_Email VARCHAR(60) NOT NULL default ''
);";

i cant spot whats wrong, any ideas??

Thanks
Adam

jpmoriarty

it's a good idea to get PHPMYADMIN and that way it will do all the debugging for you.

1st one you have two 'request_PropertyType' columns.

I think the problem with the second is that you've specified your primary key as "not null" and then have given it a null value as the default. at least that's what i think it is.

iZone

the duplicate declaration sorted that table out, but giving the username a value didn't.

Any thoughts on the second one??

Adam

goldbug

does mysql_error() give you anything?

Two things I spot:

Try putting 'PRIMARY KEY' after the column type.
Only one column can be "auto", and it must be defined as a key (Try either making the auto column part of the primary key, or create a new index for it).