LLC Staff Home | Manage Student Media | Sign Out

Student Online Audio/Video Management

Language:	END; $query = "SELECT Department from SR_department union select 'Shared' from SR_department"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row = mysql_fetch_row($result)) { if ($row[0]== $Language) { print <<$row[0] END; } else { print <<$row[0] END; } } print <<
Title:
Description:	$description
URL Header:
Direct Link:

Audio/Video Files for $title

END; $query = "SELECT Name, File, Type from MM_media where Title = '$title' order by Name"; $result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row1 = mysql_fetch_row($result1)) { print << END; } $query = "SELECT count(*) from MM_media where Title = '$title'"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); $row = mysql_fetch_row($result); print <<

Add	Name	File	Type
Delete	$row1[0]	$row1[1]	$row1[2]	Edit
		Total files: $row[0]

Title List

END; $query = "SELECT Language, Title, Description from MM_titles"; $result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); while ($row1 = mysql_fetch_row($result1)) { print << END; } $query = "SELECT count(*) from MM_titles"; $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error()); $row = mysql_fetch_row($result); print <<

Add	Language	Title Name	Description
Delete	$row1[0]	$row1[1]	$row1[2]
	Total:	$row[0]

END; ?>