-----------------------------------

Homer_simpson

Thu Aug 14, 2003 12:34 am


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   :D


-----------------------------------

Amailer

Thu Aug 14, 2003 12:37 am



-----------------------------------

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

Thu Aug 14, 2003 1:57 am



-----------------------------------

i dun see any reason to create 2 tables... i think 1 lable would do fine...
ty for answer... :D


-----------------------------------

Amailer

Thu Aug 14, 2003 2:42 am



-----------------------------------

Well its atleast better then making tables for each PM!


-----------------------------------

PaddyLong

Thu Aug 14, 2003 2:43 am



-----------------------------------

that would be retarded


-----------------------------------

Amailer

Thu Aug 14, 2003 2:52 am



-----------------------------------

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)