MySQL incorrect syntax

major

I have been using a dev dreams tutorial, but i have a syntax error 1064 when ever run the sql script or input at the mysql monitor, the error is on two coll's 'id' INT(5) and 'date_expire' VARCHAR (10) can anyone see what's wrong?

CREATE TABLE 'members' (
'id' INT(5) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
'member_id' VARCHAR(11) DEFAULT '000-000-000' NOT NULL ,
'name' VARCHAR(75) NOT NULL ,
'email' VARCHAR(50) NOT NULL ,
'username' VARCHAR (20) NOT NULL ,
'password' VARCHAR (15) NOT NULL ,
'date_signed' VARCHAR (10)  DEFAULT '00/00/0000' NOT NULL ,
'date_expire' VARCHAR (10) DEFAULT '00/00/0000' NOT NULL ,
PRIMARY KEY ('id') ,
INDEX ('date_signed' ,'date_expire') ,
UNIQUE ('member_id')
)
TYPE = MYISAM ;

Python

can you point me to the exact url of the tutorial - which one is it?

major

http://www.devdreams.com/phptutorials_membershipsystem.php This one, it's the first bit, i've done the rest !!!!!!

Python

since that tutorial was sent in by one of our visitors I myself dont know much about it. However some of the members here might

major

Thanks Anyway

Arestia

what will this table be used for.

it seems like you could have a more logical design for this table which would be easier to create.

-Dan

Python

take a look at http://www.devdreams.com/phptutorials_membershipsystem.php to find out what its for

Arestia

ahhh more clear now

Forge

I dun exactly see anything wrong with it, try inputing the cols manually into phpMyAdmin use the values they gave. and if it comes out with the same error, tell us.

lhekitel

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/lhekitel/public_html/login.php on line 73

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lhekitel/public_html/login.php on line 81
Username and passwords do not match our records



i get this what is it?