- Tracking a conversation in PHP MYSQL
- person 'hi how are you?' stat_id = 1 rep_to_stat_id = blank
- me 'ok, and you?' stat_id = 2 rep_to_stat_id = 1
- person 'are you stalking me' stat_id = 3 rep_to_stat_id = 2
- me 'no you are stalking me' stat_id = 4 rep_to_stat_id = 3
- person text conversation_id reply_num
- ------------------------------------------------------------------
- 0 "Hi" 0 0
- 1 "Hello, who are you" 0 1
- 0 "I am a bot" 0 2
- 1 "Goodbye" 0 3
- 0 "Hi" 1 0 //new conversation thread
- 1 "who is this?" 1 1
- 0 "This is a bot" 1 2
- 1 "leave me alone" 1 3
Don't like ads? PRO users don't see any ads ;-)
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
create a new version of this paste
RAW Paste Data