shadiadiph Posted January 11, 2009 Share Posted January 11, 2009 Hi I am creating an email function so users can email each other I have been thinking about this for sometime. I would like peoples opinion on how to approach this is it better to use one table with field inbox sent trash or would it be better to make a table for each one inbox sent trash?? Link to comment https://forums.phpfreaks.com/topic/140350-need-some-advice-on-a-mail-table/ Share on other sites More sharing options...
fenway Posted January 11, 2009 Share Posted January 11, 2009 A single table per user-anything is rarely a good idea. Link to comment https://forums.phpfreaks.com/topic/140350-need-some-advice-on-a-mail-table/#findComment-734576 Share on other sites More sharing options...
shadiadiph Posted January 11, 2009 Author Share Posted January 11, 2009 yep you are right usually when you have almost finished something you realise it won't work and have to start again. Link to comment https://forums.phpfreaks.com/topic/140350-need-some-advice-on-a-mail-table/#findComment-734590 Share on other sites More sharing options...
dclamp Posted January 11, 2009 Share Posted January 11, 2009 Here is how i set up my tables for messaging: messages (msgID, folderID, toID, fromID, subject, body, timestamp, status) folders (folderID, userID, foldername) Im assuming you already have a users table. Link to comment https://forums.phpfreaks.com/topic/140350-need-some-advice-on-a-mail-table/#findComment-734595 Share on other sites More sharing options...
shadiadiph Posted January 12, 2009 Author Share Posted January 12, 2009 thanks dclamp i shall have a look into that Link to comment https://forums.phpfreaks.com/topic/140350-need-some-advice-on-a-mail-table/#findComment-735305 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.