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

[ryoka012]

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

[guido2004]

i cant echo out the specific the message of the respondent.

Why? Do you get an error?