Pm system

[haseeb]

Hi guys
Currently i have done a registration system and a login system also and want to create a Private message system but iam confused about the process of it i mean how can i make it work.
I have a database where one table is Users table and the other will be PM table how can i connect them i mean use together to run the private message system?

[Fou-Lu]

That's the easy part, it can be as simple as:

+-----------------------+
| PrivateMessage        |
+-----------------------+
| fromUser [PK][FK]     |
| toUser [PK][FK]       |
| sentDateTime [PK]     |
| message               |
+-----------------------+

Where fromUser and toUser are foreign keys to the user table. Then you simply select based on the current user. toUser would be in, and fromUser would be sent.

[haseeb]

Thanks but What it actually does a little bit more explaination ? Iam currently new to it.
You are saying that fromuser and touser are foreign keys to the user table but to which column there?

[Fou-Lu]

Originally Posted by haseeb

Thanks but What it actually does a little bit more explaination ? Iam currently new to it.
You are saying that fromuser and touser are foreign keys to the user table but to which column there?

Whatever your primary key is.