PM System
Posted: Tue Oct 17, 2006 3:20 pm
Hi,
I am tidying up a pm system I made awhile ago .. A few questions I have.
When a message is submited, I write two copys of the message to the same table, in the table I have a field called "sent" one message gets marked with "1" for inbox, the other "0" for outbox. Is that okay or should I really be storing inbox and outbox PM's to seperate tables?
Also I store the users name of the sender and the receiver in the database as well for ease of getting all the data I need for output. Should I be storing the userid's instead and use joins in the query to get the user names for output?
Thanks
I am tidying up a pm system I made awhile ago .. A few questions I have.
When a message is submited, I write two copys of the message to the same table, in the table I have a field called "sent" one message gets marked with "1" for inbox, the other "0" for outbox. Is that okay or should I really be storing inbox and outbox PM's to seperate tables?
Also I store the users name of the sender and the receiver in the database as well for ease of getting all the data I need for output. Should I be storing the userid's instead and use joins in the query to get the user names for output?
Thanks