Jump to content

PM system


jaymc

Recommended Posts

I'm about to start making a PM system for my website

Before I do, just wondering if anyone has any tips or things to concidered before creating the database structure

To put it simply, Every message sent by a user goes into the 1 table. The way a user gets their own messages is query the database for rows that match their User ID

is that the best way?
Link to comment
Share on other sites

Oh. Well, im not going to allow 'carbon copying' messages for anyone..

However, I will have a mass PM for admin. Obviously it would be pointless having the same message in x amount of rows for each member

So, I was going to set the QUERY to look for all rows which have the TO field matching their username, aswell as querying for any FROM rows that contain 'admin'

In other words, the query searches for matches to their username and messages from Admin

Sound the logic?

Here is the Structure

[code]
ID
TO
FROM
DATE
MESSAGE
IP
ATTATCH[/code]

Any suggestions for another field I may want to include?
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.