header(
"Content-Type:text/html;charset=GB2312"
);
$pagesize
=10;
$result
= mysql_query(
"Select count(DISTINCT hotelname) FROM "
.TBL_HOTELS);
$myrow
= mysql_fetch_array(
$result
);
$numrows
=
$myrow
[0];
$pages
=
intval
(
$numrows
/
$pagesize
);
if
(
$numrows
%
$pagesize
)
$pages
++;
if
(isset(
$_POST
[
'page'
])){
$page
=
intval
(
$_POST
[
'page'
]);
}
else
{
$page
=1;
}
$first
=1;
$prev
=
$page
-1;
$next
=
$page
+1;
$last
=
$pages
;
$offset
=
$pagesize
*(
$page
- 1);
$result
=mysql_query(
"select `hotelname` , count( * ) from "
.TBL_HOTELS.
" GROUP BY `hotelname` order by id desc limit $offset,$pagesize"
);
$num
= mysql_num_rows(
$result
);
while
(
$row
= mysql_fetch_array(
$result
,MYSQL_NUM)) {
$hotelname
[] =
$row
[0];
$countpeople
[] =
$row
[1];
}
for
(
$a
=0;
$a
<
$num
;
$a
++)
{
echo
"<TABLE style=\"MARGIN-BOTTOM: 20px\" cellSpacing=0 cellPadding=0 width=100% border=0>\n"
;
echo
"<TBODY>\n"
;
echo
"<TR>\n"
;
echo
"<TD style=\"PADDING-TOP: 5px\" vAlign=top align=left width=80>\n"
;
echo
"</TD>\n"
;
echo
"<TD style=\"PADDING-TOP: 5px\" align=left width=100%><A title=$hotelname[$a] style=\"FONT-SIZE: 14px\" href=#>$hotelname[$a]</A>\n"
;
echo
"</TD></TR>\n"
;
echo
" <TR>\n"
;
echo
"<TD></TD>\n"
;
echo
"<TD style=\"PADDING-LEFT: 0px\">\n"
;
echo
"<IMG src=\"images/comment.gif\" border=0> 推荐人数:($countpeople[$a]) |\n"
;
echo
"<SPAN>平均分:<STRONG></STRONG> ("
.
$count
.
"票) | 评论数:()</SPAN>\n"
;
echo
"</TD></TR></TBODY></TABLE>\n"
;
}
echo
"<TABLE style=\"MARGIN-TOP: 30px\" cellSpacing=0 cellPadding=0 width=\"100%\""
;
echo
"border=0>"
;
echo
"<TBODY><TR><TD colSpan=3 height=20>"
;
echo
"<p align=center>"
;
echo
"<P align=left><FONT color=red>第"
.
$page
.
"页/总"
.
$pages
.
"页 | 总"
.
$numrows
.
"条</FONT> | "
;
if
(
$page
>1)
echo
"<a onclick=\"viewpage("
.
$first
.
")\" href='#'>首页</a> | "
;
if
(
$page
>1)
echo
"<a onclick=\"viewpage("
.
$prev
.
")\" href='#'>上页</a> | "
;
if
(
$page
<
$pages
)
echo
"<a onclick=\"viewpage("
.
$next
.
")\" href='#'>下页</a> | "
;
if
(
$page
<
$pages
)
echo
"<a onclick=\"viewpage("
.
$last
.
")\" href='#'>尾页</a>"
;
echo
"转到第 <INPUT maxLength=3 size=3 value=1 name=goto_page> 页 <INPUT hideFocus onclick=\"viewpage(document.all.goto_page.value)\" type=button value=Go name=cmd_goto>"
;
echo
"</P></p></TD></TR></TBODY></TABLE>"
;