楼上说得似乎也是个方法,可以利用各个时间段执行不同的sql语句来显示不同的数据。好办法!ajax还是比较麻烦的,楼上的办法实现起来很容易。思路: 首先定出几个时间段,比如00:00:00-07:59:59,08:00:00-15:59:59,16:00:00-23:59:59分别写出几种你想执行的SQL语句。比如 if([第一个时间段]) $sql = "select * from table order by id asc limit 5"; if([第二个时间段]) $sql = "select * from table order by id desc limit 10"; if([第三个时间段]) $sql = "select * from table where user = 'tom'";$res = mysql_query($sql);这样实现就非常简单了
<html> <head> <script language=javascript> var secondSub = 0; var arr = new Array('3','2','4','6','8','9'); var stime = new Date().getTime()/1000; var sstation = 0; function meizzTime(n) { var mei = new Date(); mei.setTime(mei.getTime()+n*1000); //得到一个新的时间 var h = (mei.getHours()>9)?mei.getHours():"0"+mei.getHours(); var m = (mei.getMinutes()>9)?mei.getMinutes():"0"+mei.getMinutes(); var s = (mei.getSeconds()>9)?mei.getSeconds():"0"+mei.getSeconds(); document.meizz.clock.value = h+":"+m+":"+s; var cha = new Date().getTime()/1000-stime; if(cha > 10){ stime = new Date().getTime()/1000; sstation = sstation+2; } document.getElementById("show1").innerText = arr[sstation]; document.getElementById("show2").innerText = arr[sstation+1]; setTimeout("meizzTime(secondSub)",1000);
我刚才给你的只是种思路,至于想先哪10条再哪10条的就看你sql怎么写了啊!01:00:00 - 02:00:00显示最先10条不就是select * from table where id < 11,02:00:00 - 03:00:00不就是select * from table where id > 10 and id < 21嘛。 你根据不同的时间段让他执行不同的sql不就完了
加上后面补充的就不会UNFIND了 只是一个例子啊 数据可以根据自己需要来啊
<html> <head> <script language=javascript> var secondSub = 0; var arr = new Array('3','2','4','6','8','9'); var stime = new Date().getTime()/1000; var sstation = 0; function meizzTime(n) { var mei = new Date(); mei.setTime(mei.getTime()+n*1000); //得到一个新的时间 var h = (mei.getHours()>9)?mei.getHours():"0"+mei.getHours(); var m = (mei.getMinutes()>9)?mei.getMinutes():"0"+mei.getMinutes(); var s = (mei.getSeconds()>9)?mei.getSeconds():"0"+mei.getSeconds(); document.meizz.clock.value = h+":"+m+":"+s; var cha = new Date().getTime()/1000-stime; if(cha > 10){ stime = new Date().getTime()/1000; sstation = sstation+2; if(sstation >= arr.length){ sstation=0; } } document.getElementById("show1").innerText = arr[sstation]; document.getElementById("show2").innerText = arr[sstation+1]; setTimeout("meizzTime(secondSub)",1000);
首先定出几个时间段,比如00:00:00-07:59:59,08:00:00-15:59:59,16:00:00-23:59:59分别写出几种你想执行的SQL语句。比如
if([第一个时间段])
$sql = "select * from table order by id asc limit 5";
if([第二个时间段])
$sql = "select * from table order by id desc limit 10";
if([第三个时间段])
$sql = "select * from table where user = 'tom'";$res = mysql_query($sql);这样实现就非常简单了
<head>
<script language=javascript>
var secondSub = 0;
var arr = new Array('3','2','4','6','8','9');
var stime = new Date().getTime()/1000;
var sstation = 0;
function meizzTime(n)
{
var mei = new Date();
mei.setTime(mei.getTime()+n*1000); //得到一个新的时间
var h = (mei.getHours()>9)?mei.getHours():"0"+mei.getHours();
var m = (mei.getMinutes()>9)?mei.getMinutes():"0"+mei.getMinutes();
var s = (mei.getSeconds()>9)?mei.getSeconds():"0"+mei.getSeconds();
document.meizz.clock.value = h+":"+m+":"+s;
var cha = new Date().getTime()/1000-stime;
if(cha > 10){
stime = new Date().getTime()/1000;
sstation = sstation+2;
}
document.getElementById("show1").innerText = arr[sstation];
document.getElementById("show2").innerText = arr[sstation+1];
setTimeout("meizzTime(secondSub)",1000);
}
</script>
<meta http-equiv='Content-Type' content='text/html;charset=gb2312'>
<meta http-equiv="refresh" content="1000">
<title>取服务器端时间(秒数)</title>
</head>
<body onload="meizzTime(secondSub)">
<form name="meizz"><input name="clock" size="8">
<br>
<div id="show1"></div>
<div id="show2"></div>
</form>
</body>
</html>
if(cha > 10){
stime = new Date().getTime()/1000;
sstation = sstation+2;
if(sstation >= arr.length){
sstation=0;
}
}
你根据不同的时间段让他执行不同的sql不就完了
只是一个例子啊 数据可以根据自己需要来啊
<head>
<script language=javascript>
var secondSub = 0;
var arr = new Array('3','2','4','6','8','9');
var stime = new Date().getTime()/1000;
var sstation = 0;
function meizzTime(n)
{
var mei = new Date();
mei.setTime(mei.getTime()+n*1000); //得到一个新的时间
var h = (mei.getHours()>9)?mei.getHours():"0"+mei.getHours();
var m = (mei.getMinutes()>9)?mei.getMinutes():"0"+mei.getMinutes();
var s = (mei.getSeconds()>9)?mei.getSeconds():"0"+mei.getSeconds();
document.meizz.clock.value = h+":"+m+":"+s;
var cha = new Date().getTime()/1000-stime;
if(cha > 10){
stime = new Date().getTime()/1000;
sstation = sstation+2;
if(sstation >= arr.length){
sstation=0;
}
}
document.getElementById("show1").innerText = arr[sstation];
document.getElementById("show2").innerText = arr[sstation+1];
setTimeout("meizzTime(secondSub)",1000);
}
</script>
<meta http-equiv='Content-Type' content='text/html;charset=gb2312'>
<meta http-equiv="refresh" content="1000">
<title>取服务器端时间(秒数)</title>
</head>
<body onload="meizzTime(secondSub)">
<form name="meizz"><input name="clock" size="8">
<br>
<div id="show1"></div>
<div id="show2"></div>
</form>
</body>
</html>