<?php /*?><?
$id=$_GET['id'];
mysql_connect('localhost', 'root' , '');
@mysql_select_db('xbmc_video') or die( "Unable to select database");
$query="SELECT * FROM movie where idmovie='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();


$filename="SELECT movie.idmovie, files.strFilename
FROM movie, files
WHERE movie.idfile = files.idfile and idmovie ='<? echo $id; ?>'" ;


$id=mysql_result($result,$i,"idmovie");
$movietitle=mysql_result($result,$i,"c00");
$movieyear=mysql_result($result,$i,"c07");
$movieimdb=mysql_result($result,$i,"c09");
$moviethumb=mysql_result($result,$i,"c08");
$moviefanart=mysql_result($result,$i,"c20");

$regexp1 ="/http:\/(.*?).jpg/";

preg_match_all($regexp1, $moviethumb, $test);
preg_match_all($regexp1, $moviefanart, $moviefanartE);

?>
<?php */?>

<?php
$id=$_GET['id'];
mysql_connect('localhost', 'root' , '');
@mysql_select_db('xbmc_video') or die( "Unable to select database");
$query = "SELECT
movie.idmovie       as id,
movie.c00           as movietitle,
movie.c01           as moviestoryshort,
movie.c03           as movietagline,
movie.c04           as c04,
movie.c05           as movieimdbrating,
movie.c07           as movieyear,
movie.c08           as movieposterurl,
movie.c09           as movieimdburl,
movie.c11           as movieruntime,
movie.c12           as movierating,
movie.c14           as moviegenre,
movie.c15           as moviedirector,

files.strFilename   as moviefilename

FROM movie, files
WHERE movie.idfile = files.idfile and idmovie ='$id'";

$result = mysql_query($query) or die(mysql_error());
$posterurl = array();


// Print out the contents of each row into a table
while($row = mysql_fetch_array($result))

{
?>

<table border="1" cellspacing="0" cellpadding="0">
  <tr>
    <th scope="col">Movie</th>
  </tr>
  <tr>
    <td><? echo $row['id']; ?></td>
  </tr>
  <tr>
    <td><? echo $row['movietitle']; ?></td>
  </tr>
  <tr>
    <td><? echo $row['moviefilename']; ?></td>
  </tr>
  <tr>
    <td><? echo $row['movieposterurl']; ?></td>
  </tr>
</table>