I am trying to wright a script that will display a list of club memberships. But... Some memberships are family and have multiple people in them. I want one row for each membership, not each person.
Like this:
Code: Select all
------------------------------------------------------------------
| John Doe | 487-594-2467 | john@simesite.net |
------------------------------------------------------------------
| Jack Off | 785-534-3569 | jack@freemail.com |
------------------------------------------------------------------
| Paul Easy | 785-634-2599 | me@you.bla |
| Joe Easy | 785-634-2599 | notme@you.bla |
------------------------------------------------------------------
| B. Johnson | 689-444-9595 | bigjohnson@n.com |
------------------------------------------------------------------Now I have the idea of assigning each “membership” (not member) a membership id #, I was thinking For the 50 members I already have I would just assign one and from now on just use a time stamp? This would give me unique numbers and I am thing that there should be some way to do an “if” statement and use that #?
Each person is a separate row in the DB, I am trying to figure out the best way to be able to recognize two (or more) people being in the same family.
Any suggestions would be helpful.
Thanks Me!