JonnySnip3r Posted July 29, 2010 Share Posted July 29, 2010 Hey guys im making a comment system where members can type a message to another member and then the other member can log in from their account and see the comment and then post a message and visa versa. Anyways i have been trying different wayts but cant think or get it to work correctly so could someone point me in the right direction of a database structure? that way i could work from that and finish this brain swelling thing haha. Thanks guys below is my current structure. message_id tinyint(4) No None auto_increment message_to_member_id tinyint(4) No None message_from_member_id tinyint(4) No None message_title varchar(128) latin1_swedish_ci No None message_content text latin1_swedish_ci No None message_time_date varchar(128) latin1_swedish_ci No None member_image varchar(128) latin1_swedish_ci No None message_reported tinyint(4) No None message_reply tinyint(4) No None message_reply_id i have a function i created where u pass in the member_id and it spits out the name hope someone can help thanks! Quote Link to comment Share on other sites More sharing options...
petroz Posted July 29, 2010 Share Posted July 29, 2010 Just start playing with it. It looks like your headed in the right direction. Although, things will prob change slightly as you go. Quote Link to comment Share on other sites More sharing options...
JonnySnip3r Posted July 30, 2010 Author Share Posted July 30, 2010 Thanks dude well i have all day now so hopefully will manage to get it working haha Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.