Small Chatroom Problem

SD-Syndicate

Hi all,

Im trying to make a simple chatroom box that displays the new messages from bottom to top, At the moment its displaying the newest at the top and was wondering if theres a way to reverse this?

Also if any one has any ideas, Can you the get the page to scroll to the bottom automatically? Ive tried a anchor and <body onload> but to no prevail.

You can have a look at what Im talking about at the link below, Click 'Test Open Chat'

Any help is greatly appreciated thanks 🙂

http://www.syndicatesdomain.co.uk/index2.php

weekender

sorry - we can't change the order of your features just by looking at the page!

post some relevant code showing where you fetch your rows from the db/filesystem, and maybe someone will be able to help

adam

alvinkoh

You probably have to reverse your array/query to get the oldest messages at the top.

Also, in order to scroll to the bottom, you will need some form of Javascript. Do a search for "scrollTo" and you may find what you're looking for.

One of the more efficient ways of getting a simple chatroom up is for your main page to load all the relevant javascript functions to write to an output (chat) box with the properly formatted messages.

This way, all new lines of messages are appended to the end/bottom of the page via javascript (search: writeln, innerHTML). The overhead is much lesser in this case.

Cheers.
Alvin

SD-Syndicate

To be honest Im just using a simple repeat region to display messages

$maxRows_RantBox = 20;
$pageNum_RantBox = 0;
if (isset($_GET['pageNum_RantBox'])) {
  $pageNum_RantBox = $_GET['pageNum_RantBox'];
}
$startRow_RantBox = $pageNum_RantBox * $maxRows_RantBox;

mysql_select_db($database_lgmbkjfy, $lgmbkjfy);
$query_RantBox = "SELECT * FROM chat_room ORDER BY id DESC";
$query_limit_RantBox = sprintf("%s LIMIT %d, %d", $query_RantBox, $startRow_RantBox, $maxRows_RantBox);
$RantBox = mysql_query($query_limit_RantBox, $lgmbkjfy) or die(mysql_error());
$row_RantBox = mysql_fetch_assoc($RantBox);

if (isset($_GET['totalRows_RantBox'])) {
  $totalRows_RantBox = $_GET['totalRows_RantBox'];
} else {
  $all_RantBox = mysql_query($query_RantBox);
  $totalRows_RantBox = mysql_num_rows($all_RantBox);
}
$totalPages_RantBox = ceil($totalRows_RantBox/$maxRows_RantBox)-1;

And thanks for the info Alvinkoh I`ll certainly look into those javascript functions 🙂

drawmack

change DESC to ASC in your query and it will revers the order of the chat box.