Simple Chatroom with PHP & jQuery

[Jaan]

[Jordan]

The end result sure does look a lot more complicated than you make it appear above. Nice tutorial and nice work! +rep

[Jaan]

Hehe yes I know it looks complicated but it's really very simple..
and thank you

[WingedPanther]

Very cool

[Jaan]

Yea.. I'm working on it atm.. I believe it will be my next project.. I just wanted to post it here so you can do something cool also

[Jordan]

Does it still use to many system resources?

[John]

Does it still use to many system resources?

He is selecting ALL the entries from the chat table, so I'd assume once the table reaches ten thousand+ entries, it would probably be enough to kill the mysql server.

[Jaan]

Yes.. that's why i made a deletion script that deletes some of posts..like.. in every 100 posts it deletes 50

[John]

I *think* if you limit the output in the query, it won't cause such a large load if you have a large data set, this way you will be able to keep chat logs.

$sql = "SELECT time,user,text FROM chat ORDER BY time DESC LIMIT 50"; 

[Jordan]

lol, how does that help? You just listed every field in the chat table. Select * is effectively the same with less typing.