[m-e-g-a-z]

Hi, i am quite new to php and ive created this php code below and i dont know what ive done wrong. It prints out the else statements error message stating no table created?

<?php
include_once"connect.php";
$result="CREATE TABLE myMembers (
id int(11) NOT NULL auto_increment,
firstname varchar(255) NOT NULL,
lastname varchar(255) NOT NULL,
address1 varchar(255) NOT NULL,
address2 varchar(255) NOT NULL,
county varchar(255) NOT NULL,
city varchar(255) NOT NULL,
postcode varchar(255) NOT NULL,
phone varchar(255) NOT NULL,
bio_body text NOT NULL,
website varchar(255) NULL,
youtube varchar(255) NULL,
email varchar(255) NOT NULL,
password varchar(255) NOT NULL,
sign_up_date date(255) NOT NULL default '0000-00-00',
last_log_date date(255) NOT NULL default '0000-00-00',
account_type enum ('a','b','c') DEFAULT 'a',
account_notes varchar(255) NOT NULL,
email_activated enum('0','1')NOT NULL DEFAULT '0',
PRIMARY KEY(id),
UNIQUE KEY email(email))";
if(mysql_query($result)){
echo"Sucess in table creation!...
<br/><br/><b>That completes table setup<br/>
gfdsgsdfgdg</b>";
}
else {

print "no table created";

}
exit();

?>

Edit: typo error

This post has been edited by m-e-g-a-z: 28 February 2010 - 12:04 PM

[JackOfAllTrades]

See my post here

[m-e-g-a-z]

I fixed the problem...setting the amount of characters (255) in the date. Removed it and its working.

[JackOfAllTrades]

Excellent, but anyone reading this: please take the advice in the linked post to heart. If people did what was in that post from the get-go, half the questions on PHP forums would disappear.