pagegen

Hi mate, sorry didnt mean it that way, your idea is great and I will go with it, just wanted to share what I had in mind to see what you thought Thank you

I was thinking one table named 'members' which stores fields like username, password, name and a 2nd table which extends members and has all the fields I need like age, etc which will not be needed in members then I can do an INNER JOIN so somet like this members: id | name | username | password | user_type_id members_customers: member_id | age | sex | address what do you guys think

Hi guys I am making a mysql (most uptodate version), php (v5) web application I am making a system which allows multiple user types to login so we will have admin, user, affliates, and customers I can create a table called members and enter all the records in there and have a field which determins what the user type is. The issue is some members i.e customers will have other fields like age, date of birth etc so they will be extra fields for admin, users and affliates can someone please advice me on how they would do this