";
printhtmlpageheader();
print "
録画ライブラリ表示
再生可能ライブラリを表示します。
";
}
////////////////////////////////////////////////////////
//レコードの総数取得
$query = "
SELECT
COUNT(DISTINCT tid)
FROM foltia_mp4files
";
$rs = sql_query($con, $query, "DBクエリに失敗しました");
$rowdata = $rs->fetch();
$dtcnt = htmlspecialchars($rowdata[0]);
//echo $dtcnt;
//
if (! $rowdata) {
die_exit("番組データがありません
");
}
////////////////////////////////////////////////////////
//Autopager
echo "
";
//新仕様 /* 2006/10/26 */
$query = "
SELECT foltia_mp4files.tid,foltia_program.title , count(foltia_mp4files.mp4filename)
FROM foltia_mp4files , foltia_program
WHERE foltia_program.tid = foltia_mp4files.tid
GROUP BY foltia_mp4files.tid ,foltia_program.title
ORDER BY foltia_mp4files.tid DESC
LIMIT $lim OFFSET $st
";
//$rs = m_query($con, $query, "DBクエリに失敗しました");
$rs = sql_query($con, $query, "DBクエリに失敗しました");
$rowdata = $rs->fetch();
if ($rowdata) {
if(ereg("iPhone",$useragent)){
print "
";
}else{
print "
TID |
タイトル(内容リンク) |
内容数 |
リンク |
";
}
do {
$title = $rowdata[1];
$counts = $rowdata[2];
$tid = htmlspecialchars($rowdata[0]);
$title = htmlspecialchars($title);
$counts = htmlspecialchars($counts);
if(ereg("iPhone",$useragent)){
print "- $title
\n";
}else{
print "
$tid
|
$title |
$counts
|
しょぼかる-$tid
|
\n
";
}
} while ($rowdata = $rs->fetch());
if(ereg("iPhone",$useragent)){
print "\n\n