$idmin order by ID desc limit 200) AS dummy ORDER BY ID"); if (mysql_num_rows($sql)) { while($e=mysql_fetch_assoc($sql)) $output[]=$e; print(json_encode($output)); } else{ print("no_new"); } mysql_close(); } else{ $filename="chat_table".$postfix.".txt"; if (file_exists($filename)){ $delta_time=time()-filemtime($filename); } else{ $delta_time=1000; } if ($delta_time>5) { mysql_connect($ini['db']['host'],$ini['db']['user'],$ini['db']['pass']); mysql_select_db($ini['db']['db']); $sql=mysql_query('SET CHARACTER SET utf8'); $sql=mysql_query("SELECT * FROM (SELECT ID,user_code as user_id,nick,message,moderator,weather,day,TIMESTAMPDIFF(MINUTE,date, NOW()) AS difference FROM $table order by ID desc limit 200) AS dummy ORDER BY ID"); if (mysql_num_rows($sql)){ while($e=mysql_fetch_assoc($sql)) $output_file[]=$e; $json_file = json_encode($output_file); file_put_contents($filename,$json_file); } mysql_close(); } $data = file_get_contents($filename); print($data); } ?>