Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I'd like to create a messaging (email) system

Status
Not open for further replies.

gmagerr

Technical User
Aug 11, 2001
323
US
but i need some help.. i have a fairly good grasp on asp so far (still a newbie) did some visual basic programming in school, and have done some database stuff in UltraDev 4. So can someone kinda walk me through this process? there is one tutorial on 4guysfrom by RyanS, but the tutorial ends abruptly and he never finishes.. so anyway i've looked. this is one of my favorite forums, i know someone will at the very least be able to point me in the right direction. :)
Here's what i'd like to do. i have a site, you log in, from there you're on the main members page. it's got a modular look for example there's a logo box at the top, a side box for navigation, a main box in the middle, moreover newsfeed on the right and a footer box at the bottom. (by box i mean an html table, but they look like boxes.) i'd like to add a box over the moreover newsfeed that contains a user control panel where they will see if they have new mail and any other stuff like changing their account info. That's good to start with.. thanks guys.
 
Well start by making sure your members have a unique member ID in their database table.

Then create a table for messages with simply a few fields.
messages
Code:
MessageID (Unique)
FromID (From user ID)
Subject
Body
Then create one more table for assigning message to the To members.
messagelink
Code:
MessageID (Relates to message table)
ToID  (To user ID)
So if a member or admin sends one message to three members, that would create one record in the message table and three records in the message/member link table.

Now when the member home page logs in, create a joined recordset filtered to the ToID in the messagelink table for the current member.

The rest is all database stuff.

ToddWW
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top