Multiple logins

jhlew

I know this sounds weird, but I am creating a website that uses php and mysql and I want a user to be able to add email address to their own account so that they can login to the same account with different emails and the same password. Any ideas how to set of my database and/or what functions I could use in the PHP coding.

p.s. I already have the website set up and working where the user creates an account and the initial email address used becomes their login. so the database has a table set up for email.

thanks.

laserlight

Create another tables for email addresses, and have a foreign on that table refer to the id of the other table with the passwords (and name, etc).

jhlew

do i just create a different column for each email address and just have one column named id that connects to the table with all the other user information in it?

laserlight

jhlew wrote:
do i just create a different column for each email address and just have one column named id that connects to the table with all the other user information in it?

You should create a different row for each email address. Yes, a foreign key to the user table is the right approach.

jhlew

okay thank you. one more question.

when I am using the JOIN statement to pull information from the two tables ... how do I set the WHERE condition to continue the same session and read the match the foreign key. this is what I have right now.

$id = $_SESSION['id'];
$sql_default = mysql_query("SELECT * FROM myMembers INNER JOIN email_addresses WHERE id='$id' AND myMembers.id=email_addresses.mem_id");

This does not work. any ideas?

leatherback

$sql_default = mysql_query("
  SELECT * 
  FROM myMembers 
  INNER JOIN email_addresses 
  ON myMembers.id=email_addresses.mem_id 
  WHERE id='$id' 
  ");

jhlew

that does not work correctly. it gives me this

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

jhlew

nevermind... its working. THANK YOU