Student Online Audio/Video Management
Accessible Titles for $mmuser
| Add |
Language |
Title |
END;
$query = "SELECT MM_titles.Language, MM_titles.Title from MM_access, MM_titles where MM_access.UserName = '$mmuser' and MM_titles.Title = MM_access.Title";
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
Delete |
$row1[0] |
$row1[1] |
END;
}
$query = "SELECT count(*) from MM_access, MM_titles where MM_access.UserName = '$mmuser' and MM_titles.Title = MM_access.Title";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
|
|
Total: $row[0] |
|
Update Password
User List
| Add |
User Name |
END;
$query = "SELECT UserName from MM_user";
$result1 = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row1 = mysql_fetch_row($result1))
{
print <<
Delete |
$row1[0] |
END;
}
$query = "SELECT count(*) from MM_user";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
print <<
|
Total: $row[0] |
|
END;
?>
