|
print <<Audio/Video Files for $title
|
Name |
File |
|
END;
$query = 'SELECT f.id, f.name, f.filename from OM_media as f inner join OM_titles as t on t.id=f.title where t.id = '.$id.' order by name, filename';
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
Delete |
$row1[1] |
$row1[2] |
Edit |
END;
}
$query = 'SELECT count(*) from OM_media where Title = "'.$title.'"';
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
?>
|
|
Total files: |
|
|
|