Hi,
I want to build a PHP based site with a MySQL backend that will allow users to create accounts and login etc. In addition, each user will have an Internal Mail account, for managing mail from other users (not email).
My problem is this: how do I store the mail? I can think of several possible approaches, but I am not a PHP coder by trade so I do not know of the most efficient way... or at least I don't know that I do
Creating tables for 500+ users is gonna be slightly crazy, so I am limited in how I can store the data. Currently I am considering storing all mail in a Messages table inside the main DB, with an ID field that will link it to a certain user. Then when the script is called it will just extract those with the correct ID. Would this work?
Any suggestions/insights/criticisms/advice would be much appreciated.
Thanks,
AcidTank
I want to build a PHP based site with a MySQL backend that will allow users to create accounts and login etc. In addition, each user will have an Internal Mail account, for managing mail from other users (not email).
My problem is this: how do I store the mail? I can think of several possible approaches, but I am not a PHP coder by trade so I do not know of the most efficient way... or at least I don't know that I do
Creating tables for 500+ users is gonna be slightly crazy, so I am limited in how I can store the data. Currently I am considering storing all mail in a Messages table inside the main DB, with an ID field that will link it to a certain user. Then when the script is called it will just extract those with the correct ID. Would this work?
Any suggestions/insights/criticisms/advice would be much appreciated.
Thanks,
AcidTank