Page 1 of 1

Creating a member database typa thing...

Posted: Sun Apr 21, 2002 1:56 pm
by Jim
I would like to create something where people can join my site and forums at the same time (http://www.maxxxtorque.com/prodigy).

I'd like it to be somewhat like evilwalrus.com, where you become a member of the site as well as the forums. I'd like there to be a memberlist that is updated as each member is added, and I'd like these members to become forum members, as well, with the same username and password.

Do you have any idea what I'd need to do this, or where I might look to gain some insight on this whole deal?

*edit*

I guess I could at least tell you what I think I'll have to do, right?

I figure this:

I can use a MySQL db to create at LEAST 3 tables.

One table stores usernames.
One stores passwords.
One stores email addresses.

On the page I want to use to display members and emails, I can just print those tables on to a page, right? And that way the list will always update, right?

What I'd like to know is how I would check the login of members.

And of course where I'd learn how to do all the stuff I just said I thought I'd need to do...

If that's actually what I need to do.

Posted: Sun Apr 21, 2002 3:21 pm
by jason
I only have a few minutes, so excuse the brevity of this post.
One table stores usernames.
One stores passwords.
One stores email addresses.
Rather, I suggest creating 1 table that stores the username, the password, and the email address, along with any other important details.

Probably a good place to start is here:
http://www.webmasterbase.com/article/228

This article pretty much covers the full creation of a website using PHP and MySQL.

Also, my own tutorial:

http://www.webmasterbase.com/article.php?pid=0&aid=378

I hope this helps somewhat.