= and <. This is to guarantee that we don't miss any messages that are posted at the same instant this query is executed.*/ $sql = "SELECT Message,UserName FROM jenChat_Messages INNER JOIN " . "jenChat_Users ON jenChat_Messages.UserID = jenChat_Users.UserID WHERE Posted >= '" . $_SESSION['jenChat_Prevtime'] . "' AND Posted < '" . $currtime . "' ORDER BY Posted"; $res = mysql_query($sql); ?> '; while($row = mysql_fetch_array($res)){ echo '
' . htmlspecialchars($row['UserName']) . ': ' . htmlspecialchars($row['Message']) . '
'; } echo ''; } $_SESSION['jenChat_Prevtime'] = $currtime; ?>