Can any one tell me an idea how to query a one on one chat

PHP
1

here is my innjer join…i cant echo out the specific the message of the respondent.


$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.



<?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

Why? Do you get an error?