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 Very Happy

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 Confused

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... Very Happy

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)


: