new some advice

[Paragon]

Ok I have a user login system. I added another table that will hold user profile information.

User - holds id username password email and that stuff
Member - holds id bio url picture loginid

Now loginid is the same as User id this way I will know were the info is coming from. I think this is going to work fine. I could use a little help on this though.

I just cant think of the right way to do it.

😃 Thanks everyone

[Wynder]

There are a couple of ways you can do it...

You can have all of your information for the user in one table, or you can have a user table and a profile table with the user's unique ID referenced in the profile table.

OR... if you really want to split it up for fastest searching, have a user table with UID and Profile table with a PID, then a cross reference table that just has the UID and PID.

That can create some headaches pulling information out if you're kinda new to SQL.

[Paragon]

That makes alot of sense. Man I still need to learn how to do that. HAH