SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Mar 2011
    Posts
    173
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question can any one tell me an idea how to query a one on one chat..

    here is my innjer join..i cant echo out the specific the message of the respondent.
    Code PHP:
    $msg1=mssql_query("Select * from 
    	tblTicket, tblForum, tblAttachment
    where	tblTicket.TickNo=tblForum.TicketNo and 
    	tblForum.TicketNo=tblattachment.TicketNo ");

    this is how i echo out the messages.
    Code PHP:
     
    <?php while($row1=mssql_fetch_array($msg1)){
    echo "<br>";
    ?>
    <tr align='left'>
    	<td align='left'><b><?php echo $row1['MessageBy'].":"?></b></td>
     
    	<td align='left'><?php echo  $row1['Message']?></td>
    </tr>
    <?php
    }
    ?>

    Please help..Desperate

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,500
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by ryoka012 View Post
    i cant echo out the specific the message of the respondent.
    Why? Do you get an error?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •