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]
> You 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
the
> >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
