Of course you can add any information you want into one cell. You shouldn't use the term
recvord to describe this, though, since generally a record = a row.
What you are really asking is how can you differentiante multiple bits of information placed inside a singe cell. Absolutely not a problem, as long as you are familiar with the string manipulation functions of whatever programming language you are using (such as PHP). You can then just treat the contents of that cell as a string, with a separator, such as a comma, which allows you to extract both email addresses from it. I recommend using the comma as a separator (with no spaces), rather than a line break, since it is easier to deal with programmatically. Thus a cell with multiple emails would look like "host@mail.com,newmail@host.com".
For a PHP example, if you want to extract multiple emails form the "email" column of your MySQl query, just do this:
Code:
<?php
//database connection stuff
$result = mysql_query("SELECT * FROM users");
while($row = mysql_fetch_array($result)
{
$username = $row["username"];
$password = $row["password"];
$email_array = explode(",",$row["email"]);
//separate string into array using comma as separator
}
?>
From this code, for each row of the database, you now have an array of all the user's email addresses, which you can manipulate however you want. $email_array[0] will have the first email, $email_array[1] will have the second, etc...
However, if you really want to have something like "multiple pieces of data for one user", you should consider your overall database design. Good relational database design is called "normalization" and has some very good ways of dealing with these types of problems. Example: 1 table for user name, additional table relates to username, and keeps track of multiple emails per user, in a many-to-one relationship.
not done yet) 