假定你使用mysql数据库,如果是其他数据库可查相关手册寻找对应函数,原理是一样的
mysql有一个week函数,他返回一个日期在那年的第几个星期中。所以正好使用该函数来达到你的要求
设表名为tbl_name
日期字段为date
则sql串写做
"select * from tbl_name where year(date)='$year' and week(date)=$week"
其中$year为待查询的年份,$week为第几周
mysql有一个week函数,他返回一个日期在那年的第几个星期中。所以正好使用该函数来达到你的要求
设表名为tbl_name
日期字段为date
则sql串写做
"select * from tbl_name where year(date)='$year' and week(date)=$week"
其中$year为待查询的年份,$week为第几周
我给我的分页程序 你看看 该怎么弄啊 急死了我了 把你说的那么WEEK 放在哪里呢 记录是按日期走的 又该怎么写
<mysql_connect("localhost","root","");
$select=mysql_select_db("ws",$connect);
$result=mysql_db_query("ws","select * from member order by me_indate DESC ");
$total=mysql_num_rows($result);
$pagesize=10;
if (($total%$pagesize)!=0)
$totalpage=intval($total/$pagesize)+1;
else
$totalpage=intval($total/$pagesize);
if ($page=="")
$current=1;
else{
switch($page){
case "首页":
$current=1;
break;
case "上一页":
$current=$curpage-1;
break;
case "后一页":
$current=$curpage+1;
break;
case "尾页":
$current=$totalpage;
break;}
}
if($total<>0){
mysql_data_seek($result,(($current-1)*$pagesize));
}
$i=1;
//while($row=mysql_fetch_row($result))
//{
//echo "<tr>";
//echo "<td width=51%><div align=center>"."<a href=DisplayTopic.php?id=".$row["Message_ID"].">".$row["Message_Topic"]."</a>"."</div></td>";
//echo "<td width=14%><div align=center>"."<a href=DisplayUserinfo.php?name=".$row["Message_Auther"].">".$row["Message_Auther"]."</a>"."</div></td>";
//echo "<td width=21%><div align=center>".$row["Message_PublishTime"]."</div></td>";
//echo "<td width=14%><div align=center>"."<a href=DisplayUserinfo.php?name=".$row["Message_Auther"].">".$row["Message_Lastpost"]."</a>"."</div></td>";
//echo "</tr>";
//}
while($row=mysql_fetch_row($result))
{
echo "<tr>";
echo "<td width=51%><div align=center>".$row["1"]."</div></td>";
echo "<td width=14%><div align=center>".$row["2"]."</div></td>";
echo "<td width=21%><div align=center>".$row["7"]."</div></td>";
echo "<td width=25%><div align=center>".$row["4"]."</div></td>";
echo "</tr>";
$i++;
if ($i>$pagesize)
break; else
continue;
}
?>
</td>
</tr>
</table>
<?
echo "<form name=form1 method=post action=".$_SERVER['PHP_SELF']."> ";
echo "<input type=hidden name=curpage value=".$current."> ";
echo "<input type=submit name=page value=首页> ";
if($current>1):
echo "<input type=submit name=page value=上一页> ";
endif;
if($current<>$totalpage):
echo "<input type=submit name=page value=后一页> ";
endif;
echo "<input type=submit name=page value=尾页></form>";
?>
而要用 mysql_data_seek呢?那不是和ASP一样了,怎么体现MYSQL的优点呢呵呵