Computer Science Canada private message system |
| Author: | Homer_simpson [ 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  |
|
| Author: | Amailer [ Thu Aug 14, 2003 12:37 am ] |
| Post 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) |
|
| Author: | Homer_simpson [ Thu Aug 14, 2003 1:57 am ] |
| Post subject: | |
i dun see any reason to create 2 tables... i think 1 lable would do fine... ty for answer... |
|
| Author: | Amailer [ Thu Aug 14, 2003 2:42 am ] |
| Post subject: | |
Well its atleast better then making tables for each PM! |
|
| Author: | PaddyLong [ Thu Aug 14, 2003 2:43 am ] |
| Post subject: | |
that would be retarded |
|
| Author: | Amailer [ Thu Aug 14, 2003 2:52 am ] |
| Post 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) |
|