Index: trunk/install/php/deletemovie.php =================================================================== --- trunk/install/php/deletemovie.php (リビジョン 94) +++ trunk/install/php/deletemovie.php (リビジョン 97) @@ -82,4 +82,5 @@ $filesplit = split("-",$fName); +/* if ($filesplit[1] == ""){ $query = " @@ -90,26 +91,27 @@ AND foltia_subtitle.tid = ? "; -//$rs = m_query($con, $query, "DBクエリに失敗しました"); $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0])); $rall = $rs->fetchAll(); - $rowdata = $rall[$row]; -//print" $fName./$rowdata[1]//$rowdata[2]
\n"; + //$rowdata = $rall[$row]; + $rowdata = $rall[0]; $title = $rowdata[1]; $subtitle = ""; $count = ""; -}else{ +*/ +//}else{ $query = " -SELECT -foltia_program.tid,foltia_program.title,foltia_subtitle.countno,foltia_subtitle.subtitle -FROM foltia_subtitle , foltia_program -WHERE foltia_program.tid = foltia_subtitle.tid - AND foltia_subtitle.tid = ? - AND foltia_subtitle.countno = ? +SELECT foltia_program.tid,foltia_program.title,foltia_subtitle.countno,foltia_subtitle.subtitle +FROM foltia_subtitle , foltia_program +WHERE foltia_program.tid = foltia_subtitle.tid +AND foltia_subtitle.m2pfilename = ? "; + //$rs = m_query($con, $query, "DBクエリに失敗しました"); -$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1])); +//$rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1])); +$rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName)); $rall = $rs->fetchAll(); - $rowdata = $rall[$row]; + //$rowdata = $rall[$row]; + $rowdata = $rall[0]; //print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]
\n"; $title = $rowdata[1]; @@ -117,5 +119,5 @@ $subtitle = $rowdata[3]; -}//end if 話数がNULL +//}//end if 話数がNULL $tid = htmlspecialchars($rowdata[0]); @@ -127,5 +129,13 @@ $fName
-$title +"; + +if ($tid > 0 ){ + print "$title"; +}else{ + print "$title"; +} + +print " $count
$subtitle