If you mean making the client refresh the page after an amount of time, use header('Refresh: 10'); it is in seconds
Michiel van Heusden wrote:
thanks for your replies
the other thing i was trying to ask :) is how to keep on looping and looking for new messages is just a plain loop ok or should i use a timer or whatsoever, i have no clue
right now it's a bit like
$x = "loop";
do while ($x == "loop") { //mysql_query (select new messages) //output new messages to bottom of html }
"Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
theYou need only one query with LIMIT, example: //this will select last 10 messages $res=mysq_query('SELECT * FROM chat_messages ORDER BY addtime DESC LIMIT 10');
// this will print them from newer to older while($message=mysql_fetch_array($res)) { echo $message['from'].': '.$message[message'].'<br>'; }
the connection is closed once your script is over (unless you use pconnect), you can not really find out the window has been closed.
you don't need to worry about any crash, sql server will take care of this
Michiel van Heusden wrote:
i'm working on a chat-app which has to be extremely plain and simple mysql is available
i tried stripping some of the big scripts, but ended up in a mess so i've ended up building a little app myself
i'm just wondering whether i'm using the right principe to get the data refreshed in the chat..
i'm dropping all the messages as records in a mysql-table then i have the php script
first printing all the html>>> stuff opening a paragraph
and then a loop, querying the mysql, printing the data and querying again
is that a way to build this, or are there much better ways?
and some other questions:
* how can i make sure the db-connection is closed before the user closes
window? * is there any server-side problem with this (say, 100 people log on, and are contineously querying mysql, won't there be some sort of crash?)
thanx a lot michiel
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php