$StrSql="select * from new_news1 where newstype=$TypeID order by addtime desc";
其他没有什么错误,但是这句SQL语句有误。
select * from yourtable where conditions limit $startrow,$PageSize ...
其他没有什么错误,但是这句SQL语句有误。
select * from yourtable where conditions limit $startrow,$PageSize ...
if($TotalPages<9)
{
for($k=1;$k<=$TotalPages;$k++)
{
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=$k\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>$k </font></A>";
}
}
if($TotalPages>=9&&$CurPage<6)
{
for($k=1;$k<=9;$k++)
{
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=$k\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>$k </font></A>";
}
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=10\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>>> more</font></A>";
}
if($CurPage>5&&$TotalPages>$CurPage+4)
{
for($k=$CurPage-4;$k<=$CurPage+4;$k++)
{
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=$k\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>$k </font></A>";
}
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=$k\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>>> more</font></A>";
}
if($TotalPages>=9&&($TotalPages<$CurPage+5))
{
for($k=$TotalPages-8;$k<=$TotalPages;$k++)
{
$Page.="<A href=\"designer_trends_liuxing.php?CurPage=$k\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" color=#ffffff size=-2>$k </font></A>";
}
}