Link to home
Create AccountLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on - Chat style text box using SQL


I am busy creating a simple chat mechanism on my website. So far I have a text box
that the user can type a message in and click a Send button, which fires the message through to my SQL database. I then send a reply through to the database, but am not sure how the page will pick this question up.
Is there some kind of way to ceck for a new message in the database using a timer mechanism or perhaps some kind of emailing facility?
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If the message is inserted when the user clicks send, you can create a trigger that runs after the insert, sending a notification to you
Avatar of Murray Brown


Hi YZlat. Is that trigger something that brings it back onto the page from SQL. I'm not sure how that would work
Thanks. Great answer!