list.php

mv 具体不是很清楚

<?php
require("global.php");

$linkdb=array();

if($job=='list')
{
	$rows=20;
	if($page<1){
		$page=1;
	}
	$min=($page-1)*$rows;
	$showpage=getpage("{$pre}mv_video","WHERE uid='$lfjuid'","?job=$job",$rows);
	$query = $db->query("SELECT * FROM {$pre}mv_video WHERE uid='$lfjuid' ORDER BY id DESC LIMIT $min,$rows");
	while($rs = $db->fetch_array($query)){
		$rs[posttime]=date("Y-m-d",$rs[posttime]);
		$rs[levels]=$rs[levels]?"<font color=red>已推荐</font>":"未推荐";
		$rs[state]=$rs[yz]?"<font color=blue>已验证</font>":"未验证";
		$listdb[]=$rs;
	}
	require("head.php");
	require("template/list.htm");
	require("foot.php");
}


?>