チェンジセット 94: trunk/install/php/deletemovie.php
- コミット日時:
- 2010/02/28 22:28:26 (14 年前)
- ファイル:
凡例:
- 変更無し
- 追加
- 削除
- 更新
- コピー
- 移動
trunk/install/php/deletemovie.php
r76 r94 88 88 FROM foltia_subtitle , foltia_program 89 89 WHERE foltia_program.tid = foltia_subtitle.tid 90 AND foltia_subtitle.tid = $filesplit[0]90 AND foltia_subtitle.tid = ? 91 91 "; 92 $rs = m_query($con, $query, "DBクエリに失敗しました"); 93 $rowdata = pg_fetch_row($rs, $row); 92 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 93 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0])); 94 $rall = $rs->fetchAll(); 95 $rowdata = $rall[$row]; 94 96 //print" $fName./$rowdata[1]//$rowdata[2]<BR>\n"; 95 97 $title = $rowdata[1]; … … 103 105 FROM foltia_subtitle , foltia_program 104 106 WHERE foltia_program.tid = foltia_subtitle.tid 105 AND foltia_subtitle.tid = $filesplit[0]106 AND foltia_subtitle.countno = $filesplit[1]107 AND foltia_subtitle.tid = ? 108 AND foltia_subtitle.countno = ? 107 109 "; 108 $rs = m_query($con, $query, "DBクエリに失敗しました"); 109 $rowdata = pg_fetch_row($rs, $row); 110 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 111 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0] ,$filesplit[1])); 112 $rall = $rs->fetchAll(); 113 $rowdata = $rall[$row]; 110 114 //print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]<BR>\n"; 111 115 $title = $rowdata[1]; … … 119 123 $count = htmlspecialchars($count); 120 124 $subtitle = htmlspecialchars($subtitle); 121 122 //--123 124 125 125 126 print " … … 138 139 $query = " 139 140 DELETE FROM foltia_m2pfiles 140 WHERE m2pfilename = '$fName'141 WHERE m2pfilename = ? 141 142 "; 142 $rs = m_query($con, $query, "DBクエリに失敗しました"); 143 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 144 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($fName)); 143 145 144 146 //削除処理
