Page 1 of 1

need some ideas

Posted: Fri Aug 31, 2007 7:36 pm
by Yourchild
I am creating a page where each user can sign in and check his/her email...

What is the best way to go about implementing this procedure? Obviously I cannot store all the messages sent between users in 1 table, because if 1 user delete his emails, it wont be available for the other user to view.

This is something normal that most websites have ..just sending messages to each other ...inbox, outbox etc..

question is...should i create 2 tables with identical tuples in both tables? or should i create 1 table with duplicated tuples? a tuple is a row in a DB by the way.

Any help will be gladly appreciated. Thanks!

Posted: Fri Aug 31, 2007 7:48 pm
by aceconcepts
First of all, will these messages be actual emails?

Secondly, what exactly are you trying to do?

Posted: Sat Sep 01, 2007 12:03 am
by Yourchild
This is sending messages to one another ...equivalent to me sending you a private message on this website. It is not sending actual emails.

Posted: Sat Sep 01, 2007 5:04 am
by Kieran Huggins
I would duplicate the entry in the DB: once for the user's sent items (if necessary) and one for the other user's inbox. They should each have access to only their own copy.

Re: need some ideas

Posted: Sat Sep 01, 2007 6:33 am
by superdezign
Yourchild wrote:What is the best way to go about implementing this procedure? Obviously I cannot store all the messages sent between users in 1 table, because if 1 user delete his emails, it wont be available for the other user to view.
That's why we always have a separate "sent messages" folder, because it is actually separate data. You should also possibly give them a choice to save it or not, since it can be deleted.

Descriptive Subjects

Posted: Sat Sep 01, 2007 9:14 am
by feyd
~Yourchild, please choose a new, more descriptive subject.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.

Posted: Sat Sep 01, 2007 12:40 pm
by Yourchild
thanks for the ideas everyone. And to the moderator, I will keep the subject headers more detailed next time. thanks!