Index: trunk/install/php/folcast.php =================================================================== --- trunk/install/php/folcast.php (リビジョン 102) +++ trunk/install/php/folcast.php (リビジョン 111) @@ -52,7 +52,7 @@ SELECT foltia_program.tid,foltia_program.title, foltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime FROM foltia_subtitle , foltia_program WHERE \"pspfilename\" LIKE 'M%%' AND foltia_program.tid = foltia_subtitle.tid AND foltia_program.tid = $tid -ORDER BY \"enddatetime\" DESC -limit $max offset 0 - "; +ORDER BY enddatetime DESC + limit ? offset 0 +"; $titlequery = " @@ -63,4 +63,5 @@ // $titlers = m_query($con, $query, "DBクエリに失敗しました"); $titlers = sql_query($con, $query, "DBクエリに失敗しました",array($tid)); +// $titlers = sql_query($con, $titlequery, "DBクエリに失敗しました",array($tid)); $rowdata = $titlers->fetch(); $rsstitle = $rowdata[1]; @@ -69,7 +70,10 @@ $query = " SELECT foltia_program.tid,foltia_program.title, -foltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime FROM foltia_subtitle , foltia_program WHERE \"pspfilename\" LIKE 'M%%' AND foltia_program.tid = foltia_subtitle.tid ORDER BY \"enddatetime\" DESC -offset 0 limit ? +foltia_subtitle.countno , foltia_subtitle.subtitle , foltia_subtitle.startdatetime, foltia_subtitle.pspfilename,foltia_subtitle.lengthmin,foltia_subtitle.enddatetime FROM foltia_subtitle , foltia_program WHERE \"pspfilename\" LIKE 'M%%' AND foltia_program.tid = foltia_subtitle.tid ORDER BY enddatetime DESC +limit ? offset 0 "; + + + $rsstitle = "新規録画"; }//if