private message system
| Author |
Message |
Homer_simpson
|
 Posted: Thu Aug 14, 2003 12:34 am Post subject: private message system |
|
|
like the one that this site has... how do u suggest i could do it... i could add a new table for each user's message in my data base but that's not efficient way to do it... i need a way to store unlimited number of text messages for each user in my data base... suggestions will be appreciated  |
|
|
|
|
 |
Sponsor
Sponsor
|
|
|
Amailer
|
| Posted: Thu Aug 14, 2003 12:37 am Post subject: (No subject) |
|
|
Why create tables?
Make 1 table for the messages....then in there created the fields (message, username, time and etc).
And then it creats new fields with the information 
actually...
Do what phpBB did,
Create 2 tables,
1 specially for the text (with the id)
and 1 seperate witht he additional information.
(username, time, date, and etc) |
|
|
|
|
|
Homer_simpson
|
| Posted: Thu Aug 14, 2003 1:57 am Post subject: (No subject) |
|
|
i dun see any reason to create 2 tables... i think 1 lable would do fine...
ty for answer... |
|
|
|
|
|
Amailer
|
| Posted: Thu Aug 14, 2003 2:42 am Post subject: (No subject) |
|
|
| Well its atleast better then making tables for each PM! |
|
|
|
|
|
PaddyLong
|
| Posted: Thu Aug 14, 2003 2:43 am Post subject: (No subject) |
|
|
| that would be retarded |
|
|
|
|
|
Amailer
|
| Posted: Thu Aug 14, 2003 2:52 am Post subject: (No subject) |
|
|
Ya it would,
And if you don't want to make 1 table for the msg, then put all the fields in 1 table.
(I.E: Date, ip, time, username, id, msg, and etc) |
|
|
|
|
|
|
|
Register
Wiki
Blog
Search
Turing
Chat Room
Members
