wezly

Hi there, I have a very basic php chat system storing information in my db. I have made a chatlog to display the information and I would like to have that information update live with an autoscroling box, instead of having to use iframes with. <script> setTimeout("window.location.replace('chatlog.php')",700); </script> I have looked at a few tutorials but they all seem to build their own systems, nothing about integration with a current system. I have also fond solutions that refresh divs but try as I might, this does not seem to work. <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script> <script> var auto_refresh = setInterval( function() { $('#log').fadeOut('slow').load('chatlog.php').fadeIn("slow"); }, 2000); //2000 Milliseconds or 2 seconds </script> any help very much appreciated. thanks in advance.

Thank you!

hey, here is the code I am using. mysql_connect("localhost","XXXXXX","XXXXXX") or die("Could not connect."); mysql_select_db("XXXXXX"); $query="SELECT * FROM VIDEO_SESSIONS"; $result=mysql_query($query); while ($db_field = mysql_fetch_assoc($result)) { $timeslider = $db_field['timeslider']; } $message=$_POST['message']; $name=$me['first_name']; if(isset($_POST['submit'])){ if(strlen($message)<1) { print "You did not input a message"; } else if(strlen($name)<1) { print "Please login with Facebook to post a message"; } else { $insertmessage="INSERT INTO CHAT_SESSIONS (user_id,user_message,current_time) VALUES ('$name', '$message', '$timeslider')"; mysql_query($insertmessage); echo mysql_error(); } } ?> I am getting this error everytime I try and INSERT into the database " You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'current_time) VALUES ('Luke', 'Hello?', '00:23:00')' at line 2 " it works fine without the '$timeslider' which is a time stored on the database in the format 00:00:00 why does it not want to store the time back in a different table.. same format!?

It involves flocking video. once it is ready I will drop you a test link http://filmflock.co.uk this has turned in to more of a php, mySQL afair, can you help me out with the mySQL time commands? I have had a quick browse which turned up the Now() function. $query_auto = "INSERT INTO db_time (db_time) VALUE ( NOW() )"; am I looking at the right stuff?

So say every 3 seconds stamp a time to db.. then when another user trys to connect, the php checks the time on the database relative to current time and if it is say 5 seconds since a stamp then you would assume they are no longer there ?.. that's pretty smart. thanks.

Sorry, yes I must have miss read that. What I am relying on them doing is something they will inevitably do! Close The Browser ? and I trust javascript to tell me when they do it right ? The reason I want to capture this event is not because I am asking them to do it, it is because I know they will do it therefore I need the database to know when this happens. If you have a better suggestion please do tell. Wez

The Client doesn't even need to know it is happening. I assume you guys know how to do this?.. I just need the java to tell php when they close the page so that I can update the table cell to 0 so the db knows there is no one connected. or if there is a better way of doing this please tell thanks.

Hey people, thanks for you replies.. By no means do I want to 'Trap' people on the site, the reason that I need this function is so that my database knows when a user has left the page and to allow a new user to enter that page. as a Host. I would be perfectly happy not having the message, is there a way to use that function to tell php someone has closed the page? without the popup ? because I totally agree that I hate those messages! but as I have limited knowledge this seemed like a slightly easier option ?.. Wez.

Hi, What I would like to do is when a user closes the browser or tab, update a value in to mySQL cell via php. Either automatically or have a system message pop up that says "are you sure you want to close this window" and when they click yes it updates my database and then closes. I have minimal experience with java and after searching around I have not found anything useful bar the use of a possible 'on unLoad' event ? thanks in advance.

Hey, I'm pretty new to PHP, thought I would join a forum to try and learn from some seasoned professionals.. Working on a project at the moment that I'm gunna need some pointers on so expect to see me in the Help Threads!.. Peace