Create Members Area - PhpMyAdmin Database Lesson2

[MLProduction99]

how do i add the member area to my web page??

Please replay!

[MrBOBMAN567]

Hey i get #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Membership Information'' at line 14

[chingproduction]

@MrBOBMAN567 I found the problem online, and it work. try to change "TYPE=MyISAM" -> "ENGINE=MyISAM"

hope this help, cuz i had the same error and it work after i change it............

[BalliSkate]

Thanks!

I was so confused when i was trying to make this but this video helped alot.

[YouTrendsTube]

hey !!!

[geeno123]

hey there, love the tutorials!!

However when I copy and paste the database code in MySQL, I get this error:

"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='Membership Information'' at line 14"

could you tell me why this is?

[BakaAnimeFriendz]

@geeno123

I have the same problem

[mattbloom11]

hey i love your videos, they have been helping me every step of the way, but i ran into a problem, when i double click on the database.sql file it says windows cannot find this file. whats the problem?

[tinytotsjapan]

I can't open Members_Area.rar, but I can open member_lesson10.rar on my Mac. Why is this? Cheers again

[tinytotsjapan]

Hi there. When I open the .rar file on my Mac the folder is empty. How can I go about getting the code? Thanks

[tinytotsjapan]

Hi there. When I open the .rar file on my Mac the folder is empty. How can I go about getting the code? Thanks

[tinytotsjapan]

Hi there. When I open the .rar file on my Mac the folder is empty. How can I go about getting the code? Thanks

[etikem]

THANKS MAN!!! YOU HELPED ME ALOT!!!!!!!!

[asifkhanpirkani]

very hard php

[1000Jamesgames]

Hii When i copy and paste the code and click go it comes up with #1067 - Invalid default value for 'signup_date' what should i do?

[1stoptutorials]

hey 1000Jamesgames, thanks for your comment. It means you are trying to insert wrong default value of date, ok try changing the signup_date datetime from this

0000-00-00 00:00:00

to this

0001-01-01 00:00:00

Let em know how you get on

Ali

[1000Jamesgames]

@1stoptutorials ok thanks for replying but i changed it to 0001-01-01 00:00:00 but it still said #1067 - Invalid default value for 'signup_date'

[1stoptutorials]

Hey 1000Jamesgames, thanks for your comment. You could try going to here

phpfreaksdotcom as they have a great forum for php.

Let me know how you get on

Ali

[nameuunavailable]

You rock

[whatsup12312341]

you are the best man!

you Rock :D 1,000/5 :)

[Sep33]

I'd like to add a Middle Name part to the registration. What should I copy and change in the PHP and SQL?

[1stoptutorials]

To do that you would need to add some variables plus you would also need to add another table to database. Could be a little bit tricky. Thanks sep33

Ali

[Sep33]

Hey Ali, im adding table to my database but i don't know what to set table settings too, can you go through and describe what the settings mean. or could you direct me to a place that gives me that info? thanks

[1stoptutorials]

Hey sep33, thanks for the comment. If you look inside of the folder there is a text file with all the database tables. All you do is paste that in to phpmyadmin SQL section and i will create all tables for you. Let me know how you get on. Thanks Sep33

Ali