Member Comment Database Structure help please :D

[JonnySnip3r]

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!

[petroz]

Just start playing with it. It looks like your headed in the right direction. Although, things will prob change slightly as you go.

[JonnySnip3r]

Thanks dude well i have all day now so hopefully will manage to get it working haha