PHP - Moved: Php/ajax For Messaging System

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=349747.0

Looking for the best way to set-up the db of a messaging system. Here's what I have so far (basically pulled from another forum), don't know if Table1 is even really necessary:

Table1:
id
user_message_id
recepient_id
recepient_read

Table2:
user_message_id
sender_id
sender_read
subject
message
created_at
updated_at



Basically it needs to function where, someone submits a message to the admin or moderator, the admin/moderators can review and reply, and then the user can submit another reply, and keeps going indefinitely. I want each reply to show up almost like a forum thread.

How would I chain the reply messages to the original messages?

im setting up a php and jQuery pm system and have run into a problem. When a user clicks on a message in the left column the right column is supposed to be populated with the message contents, however the content stays the same whichever message is clicked.

Code: (php) [Select]
<?php
$query = $link->query("SELECT * 
                            FROM ".TBL_PREFIX."messages
                            WHERE m_sent_to = '$user_name'")
                            or die(print_link_error());
                            
        $row = $query->fetchAll();
        
        foreach($row as $key => $value)
        {
            $_message_list .= '<dl class="message_row" id="row-'.$row[$key]['m_mid'].'">';
            $_message_list .= '<dd class="message_author">'.profile_link($row[$key]['m_author']).'</dd>';
            $_message_list .= '<dd class="message_date">'.asf_date($row[$key]['m_date_sent'], 'short').'</dd>';
            
            $_message_list .= '<dd class="message_checkbox"><input type="checkbox" id="checkbox-'.$row[$key]['m_mid'].'" /></dd>';
            $_message_list .= '<dd class="message_subject">'.$row[$key]['m_subject'].'</dd>';
            $_message_list .= '</dl>';
            
            $template->message_content = $row[$key]['m_content'];
        }
?>

and the jQuery

Code: (js) [Select]
<script type="text/javascript">
                $j = jQuery.noConflict();
                $j(document).ready(function(){
                    $j('dl.message_row').click(function(){
                        $j('li.message').html('<?php echo $this->message_content; ?>');
                    });
                });
            </script>

The content display is always the content of the last message.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=319007.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=314181.0