<script tyPE="text/javascript">
VAR auto_refresh = setInterval(function () {
    $('#canvas').load('content.PHP').fadein("medium");},5000);
     // refresh every 5 seconds
</script>

$query_Recordset5 = "SELECT * From news"; 
$Recordset5 = MysqL_query($query_Recordset5,$connection) or die(MysqL_error());
$row_Recordset5 = MysqL_fetch_assoc($Recordset5);
$totalRows_Recordset5 = MysqL_num_rows($Recordset5);

如果您的表具有自动增量字段(例如“id”).首先传递page.PHP和id为0,因此它将获取大于0的自动增量字段,然后通过jquery传递那些字段ID.当您再次发送它时,它将不会包括在内,因为您将使用大于号.

if num_rows == 0检查是否有任何字段,如果没有,那么它将假设你发送的自动增量字段是最后一个,然后它将运行带有第一个自动增量值的sql语句.

<?PHP
// page.PHP
$id = (int) $_REQUEST['id'];
$sq = "select * from news where id > ".$id." order by id asc limIT 0,1";
$qu = $con->query($sq);

if ($qu->num_rows == 0) {
    $sq2 = "select * from news order by id asc limit 0,1";
    $qu2 = $con->query($s2);
    while ($fe = $qu->fetch_assoc()) {
       echo $fe['id']."|".$fe['content'];
    }
} else {
    while ($fe = $qu->fetch_assoc()) {
       echo $fe['id']."|".$fe['content'];
    }
}
?>

<script>
$(document).ready(function() {
    setInterval(function(){ updateNews(); },5000);
});
function updateNews() {
    var id = 0;
    id = $("#hidden-id").val();        

    $.get("page.PHP?id=" + id,function(data) {
       // I use $.get so that I can split the data that it returns before populating 
       // the #canvas. This way we can strip off the First part which is the auto 
       // increment
       var ref = data.split('|');
       $("#hidden-id").val(ref[0]);
       $("#canvas").htML(ref[1]);
    });
}
</script>